data extraction

S

sreekuax

Member
Have to extract data from below tables :

PL_MSTR
PT_MSTR
GLTR_HIST
CM_MSTR
SI_MSTR
AD_MSTR
CC_MSTR
VD_MSTR
PO_MSTR,
POD_DET
VO_MSTR
VOD_DET

have to use progress- the condition is that have to only extract data in each table of 2009 data only .. as u might know that full data extract will contain data regardless the year !!

Any idea ? pls help
 
You don't tell us anything about the Progress/OpenEdge version you are using.

I am not 100 % positive as to when the features was introduced into the product, but in recent version of OpenEdge 10 the binary dump has an option to specify a selection criteria - if that's what you're looking for ...

For the ASCII dump in the data administration tool there is no such option - but it's easy to code it youself:

FOR EACH <yourTable> NO-LOCK WHERE <yourWhereCriteria>:
EXPORT <yourTable>.
END.
Click to expand...


Regards, RealHeavyDude.
 
RealHeavyDude said:
You don't tell us anything about the Progress/OpenEdge version you are using.

I am not 100 % positive as to when the features was introduced into the product, but in recent version of OpenEdge 10 the binary dump has an option to specify a selection criteria - if that's what you're looking for ...

For the ASCII dump in the data administration tool there is no such option - but it's easy to code it youself:






Regards, RealHeavyDude.
Click to expand...


Bro as i said my where condition is data of these tables in the year 2009.

so how I can specify my where clause with for each.. any date fields in these tables will help me in that ???
 
Hey bro, English is not my first language, so please bear with me ...

Do you mean that you want all records which have a date value with a year of 2009 in any date field that exists in the table?

Still you don't say anything about the Progress/OpenEdge version you are running ...

Heavy Regards, RealHeavyDude.
 
RealHeavyDude said:
Hey bro, English is not my first language, so please bear with me ...

Do you mean that you want all records which have a date value with a year of 2009 in any date field that exists in the table?

Still you don't say anything about the Progress/OpenEdge version you are running ...

Heavy Regards, RealHeavyDude.
Click to expand...

Bro :

Let me be so clean :-)

my aim : to extract all the field values from above tables which is added to the table in year 2009. As you know these tables contain the data from the day one we start use eB2. so i need only 2009 data for all fields

progress version is : 9.1 D
 
You need to know which field in the table to select on. If you don't know that then your best bet would be to ask in the mfg/pro forum (down towards the bottom of the forum list...)

For example:
Code: 
output to value( "order.d" ).
for each order no-lock where order.order-date >= 1/1/2009 and order.order-date <= 12/31/2009:
  export order.
end.
output close.
 
I have absolutely no knowledge about eB2 - do these tables have a field that hold the value when a record was created?

Heavy Regards, RealHeavyDude.
 
You must log in or register to reply here.
Back
Top