DSXchange

hi
i have approximately 10000 records in a hash file and i am doing a look up on this hash file for populating the target tables.i am getting update for the hash file every 15days.so how can i refesh my hash file so that look up will be effective.i dont want to use ODBC for look up

but when i map the date coulmn in the transformer stage by default its taking time stamp.i was using the same code you suggested but instead of concatinating 00:00:00 i was using the timestamp(code...)

the incoming value in my file are not null.
i think there is some problem with the timestamp part

i am getting date fields in the file as 12252001
i want the field to load into oracle table
i am using timestamp() and iconv/oconv to insert into oracle table.
but i am getting null values when it is inserted.
how to resolve this issue

can u plz explan wat that code means..
i want the records in another flat files depending on the creation date

one more help...i need that i should read the date field and pass it as a stage variable to load it into the table..
i want to read only the records not the company name,the ********s and the blank line...
how should i do that

its working now!!!!!!!11
thanks for ur valuable help

i dont find any option as line terminator in DataStage..can you please tell me where is that option.
while importing the file there is no option as such...

hi all... in my last post i asked one question...as per the post i approached the solution but now i m facing a problem while reading the whole sequential file as a single field as am facing a problem.an error message is showing there.my file has some rows as blank and some rows have data in it.i ne...

i got the point..
now i ll implement it..
i i have any further queries i ll ask you people

hi... in my flat file i m getting a email id field..i want to validate this field before inserting it into table..the email id should be in the format xyz...@xyz...com or xyz...@xyz...co.xy.i need to write some function in the transform stage..so can u plz suggest me what code i need to write and wh...

thaks all you people for your immediate response.i hav a small doubt that how can read the file when i encounter the second generation value... if u people suggest me code of the field function it will be very helpful this is a really awesome community....i got the solution within 30mins.. one again...

thanks for your response..
the output should be a table consisting of 5 columns.3 are the fields given in the flat file.the 4th one is the generation date which is given as the header of rhe block of records and the 5th one is the load date.
plz suggest me an approach to solve it

hi all i have got a flat file to load into a table along with date..the flat file has different segments where the date value and its corresponding set of records is given..then another date value and another set of records...how to read such a file.. i m giving the format of file below generation d...