DSXchange

is this a dos file that you are ftping over to the unix and then trying to load it? At the unix level, try the command
dos2unix filename
and then see if it fixes the file

Did you try with spaces in between?

Check out Roy's reply in this post.

What table are you trying to update? From the error message that you are getting, you dont have enought privileges to do that kind of action. SQL5001N The user attempted to Update or Reset the database manager configuration file without having SYSADM authority. Thats the description i got from the I...

Please post the complete sql you are using.

The dummy key in the hashed file will be a running number, like 1,2,3...and so on. Inside the transformer, the expression of the key column will be @INROWNUM. This way each and every record will be looked up (NOTE: No matching with the source is done at this stage) All the matching is done in the st...

Congratulations Ray. Keep that candle of knowledge burning as we all find our ways in its light. Way to go. :D

The post that you have referenced, read it carefully. In that you only specify the dummy column (running number) as the key and no other key. This way you will retain each and every row and not lose any. Then you can use my derivation to get the range lookup.

Well caught.

Are you also doing clear table and then insert??? Thats why its better to start with a new post so that we can get more details. Try to decrease the commit level, this way the DB2 can swith pages and not just fill up one page for a single transaction. Also for delete its better to do as ArndW sugges...

O yes. I have been using it uptill now at times when we run out of space. But even when i go for it, i make sure i do it when there is no one logged on or no DS jobs are running in that environment. I just wanted to make sure there are no other cons with it that might prove dangerous to the project ...

Wow, i didnt know that. Thanks Dinesh for the info.

Actually i mean UNION ALL. Cat is synonymous to UNION ALL. And yes my statement above doesnt hold true as UNION does remove duplicates. For some reason i left out the 'ALL'.

Whenever you get the time Kim, please elaborate on the cons of this practice.
Is it because it loops through all the jobs. If thats the case then a person can tweak it to clear logs of only a subset of jobs by changing the source to a sequential file which has the job ids of only the a few jobs.

It depends upon how are you exactly calling the routine. If you are calling the routine in the derivation of the parameter in the sequence job then that is considered to be the default value and will be overwritten by the master control sequence parameter value if you pass one. If, however, you do n...