DSXchange

Searching for "packed decimal" in the forum will fetch the required information. Following is one such thread:

viewtopic.php?t=104742&highlight=packed+decimal

Mun... You didn't mention what database you are working with. You need to use command line database command to execute the SQLs kept in the file. For example in UDB, you can use a shell script (say loadtbl.sh) as follows: db2 connect to dbname user userid using password db2 -tvf ASSETupd.sql > ASSET...

It is highly irresponsible to post such replies in a porfessional forum like DSXCHANGE. Mods, please remove these replies from the thread to maintain the high standards of our Forum. Hi Prashant & Jothy, I understand you have a keyboard with you. It is not that you can just blindly type somethin...

Hope you are using Lookup stage in Parallel job. Lookup stage process is RAM based and you may use it only for smaller lookup tables. For larger lookup tables, consider using DISK based stages such as JOIN. One problem with Join stage is that you can't have more than one lookup table. Good Luck!

Thanks vmcburney. It works!!!

Raj.

My requirement is as follows: 1. The sequencer job need to wait for a file (say, salesdata.txt) to appear in a particular directory in unix box. 2. Once the processing is done, the file is deleted from the directory. 3. The job should go into loop and wait for a new file with the SAME name to appear...

My requirement is as follows: 1. The sequencer job need to wait for a file (say, salesdata.txt) to appear in a particular directory in unix box. 2. Once the processing is done, the file is deleted from the directory. 3. The job should go into loop and wait for a new file with the SAME name to appear...