DSXchange

Cursors are local to databases. You cannot build a curson in datastage (as far as i know) but you can surely implement the same logic within datastage job(s). My advice to you is, sit down with a cursor expert, get detailed psuedo code as to what the cursor is exactly doing and then translate that t...

or just do it at the unix level by using the wc -l command

Welcome Aboard
Try to open the dsx file in a text reader and see when was it created. Try to change the system time of your pc to a few years behind and then try. Not sure if its going to help but its worth a try.

Shell type will be 'UNIX'
Command will be the fully qualified path of your script within quotes.

If both the tables are in the same schema then you can do it in one database stage itself.
Something like

Yes, you can, go clean all the temp files, do ls -ltr and start deleting the huge files first.

After that using the Aggregator, we found the Sum value and once again we put another Aggregator, we found the Max value. Ok i am confused, you said in your descriptioin that you are getting the max value from the second aggregator and in your quest, you want to get max from the second aggregator w...

I suggest you have a friendly chat with your DBA and show him this error message, since your error message includes warning about the manager configuration file.

I wrote a script for one of my clients sometime back to get exactly that. It gives you the jobname, start time, end time, elapsed time and status of the job in a pipe delimited file such that this file can then be read by a DataStage job and loaded into a table. See if this helps. #!/usr/bin/ksh ***...

You are getting a matching record in the third row because both the keys match with the first record of your source sample data and the date is in between the start and end date. Isnt that what you want??? How it works is that with @INROWNUM in the expression of the hashed file key (dummy key), each...

You can use the dsjob -logsum/-log/-report command to view the log file. You can redirect it to a text file and view that.

Yes, when a row will be rejected, you will get warning messages. Now you have to look into those rejected rows and investigate why the FK column value is not present in the parent table. This will give you a good starting point for your investigations.

Yes, it surely works in the Notification activity. Have done that before successfully.

Well, with the lack of info about your business, i cannot tell you that, thats for you to investigate. Code columns usually end with _CD. See if you have any such column that you are loading. I am not saying that this is the problem, it might be. Chances are more of you missing a record load in the ...

Well the RI doesnt just restrict itself to parent child relationship. You could be loading a code value into the table and that code value must be missing in the code table. See if thats the case.