DSXchange

Try using a Filter on table name or owner. Overflow can occur when there are too many tables in the database. It can also occur (theoretically) when there are too many columns in a table, but I have never seen this actually happen. What does your support provider have to say? We did not ask anyone ...

Thank you very much for your replies..My process is: I will be receiving set of files daily and i have set of conditions(abt 100) to check on each of these file on each of record in it... PROCESS A In this I will read the list of files file (a file which will have list of file names wht i recvd) rec...

Hi all,
I need to do row by row processing in datastage

example:
I have JOB1 and JOB2 , JOB1 is writing some 10 records in output file
FILE1.
for each record of FILE1 i need to process JOB2 and write output.

any suggestions please welcome

regards
mahi

What were the results of your searches on the forum for "T30FILE" and for "mutex" and "timeout" ? These questions have been answered before. I am not sure of anything needs to be done at the server modifying the T30FILE or I need to change the settings in the job. As f...

Hi We are working on PS Upgrade project. In one of the Peoplesoft delivered job, we are getting an error like ds_ipcgetnext - timeout waiting for mutex Actually first time when I ran the job, I got a different error Unable to allocate Type 30 descriptor, table is full. But again when I ran it, it ra...

thanks Ray for reply,but i have the data in files so how can i accomplish outer join

thanks
mahi

Hi All, Could any one please tell me, Is it possible in datastage to do Cartesian product processing (using transformer) i.e for ex i have 2 files file1 and file2 I need to process each file1 record --> with all records of file2 I need to do this without using basic program please advise.... Mahi

Thanks a lot for the response , How can i use hash file when portion of my lookp up file field matches with data-file field.....

Mahi

Hi All, I have a requirement like this, I have a data file and lookup file in datafile i have a field called file_name which is lenght of say 50 my reqmnt is to process each record from data-file and see if any of the record from lookup file has the file_name, then that record from data-file should ...

DSguru2B wrote:Also try exporting and importing the job again.

But how do we know RT_LOGnnn belongs to which job?
Where can we find the information?

A routine that reads the mapping file then processes the data file seems to be the most viable solution. The routine can then create another file containing delimited data with column headings. You could then import the table definition from the new sequential file and design a job on that basis. T...

yep mapping file is FIXED

see basiclly I need to get the values from data file based on mapping file fields....I dont think it makes any different if fields in DAT file are delimited by space or not....just for example i have given like that
it may or may not be delimited.................

Thanks a lot for your response here am giving an example for DATAFILE the data is like this USA CONNECTICUT HARTFORD MAHI and my MAPPING file which is having fields (field name,offset,length) has data like this CNTRY 1 3 (cntry val is frm position 1 and length 3 from Data file) STATE 6 11 CITY 19 8 ...

After some research here am thinking i should go for BASIC routine.

i.e. for ach record of data file processing mapping file and writing output

DATASTAGE GURU you can suggest an alternate way....else