DSXchange

DataStage uses the crontab functionality (on UNIX) to schedule jobs. This is a UNIX command you need to execute to list what UNIX sees as the list of jobs to execute.

vrishabhsagar wrote:...I have a source file col that has decimal data in form 020...

Decimal data is not stored with leading zeroes; that is a function of how you display it. The string formatting function that
dspxlearn suggested should work for you when reconverting the number back to a string.

what does your "crontab -l" command display?

Only a few operatings sytems will do this. I recall having seen this on PRIMOS and some mainframe system (it might have been Hitachi, but that is only a guess). This won't be an issue for most systems; if you check your mainframe file system documentation you will find out if it does multiple space ...

AmeyJoshi14 wrote:... So there is no internal function Datastage which will give the above mention results.....

I guess the previous answers weren't enough: NO, there is no internal function in DataStage which can do this.

Do you have a partitioned Database? Have you tried the "load" method to the table instead of insert?

No, the sequential file stage "filter" lets you issue a UNIX command, i.e. if you put in sed '1d;$d' it would remove the leading and trailing lines (useful to get rid of header and footer lines). sed is the right way to go, it is just that I am not good enough at sed to think of how to remove the co...

Hmmm, that means this command is necessary under windows. How about trying db2cmd "db2 connect to target user user1 using pass; db2 SELECT 1 FROM SCHEMA.CUST_HDR fetch first 1 rows only; db2 connect reset;" or checking on how the db2cmd /i option might help in redirecting output. I saw thi...

Since you have a terminator, what devidotcom suggested will work perfectly.

For the <lf> error - Have you declared the <cr><lf> in your sequential file stage definitions for the "record delimiter"?

I am not any good at sed , but I am fairly certain you can write a sed command/rule which will remove the column_name strings; if you can do that the program will work a lot faster in DS since that extra data isn't processed. But if you cannot do this via sed, since this is a sequential file, you ca...

Unless your fixed-width file has record delimiters (i.e. <cr><lf>) you cannot read it if some records have different lengths. So, does your file have line/record delimiters?

The output looks just right. Remember, the DB2CMD command starts a new command shell, so the output is no longer visible and therefore your ScreenOutput is empty. Try it without the (unnecessary) DB2CMD.

Not directly. If you hard-coded the table name then it might be possible to search through the exported .dsx file and look for occurrences in different jobs.

Could you please post the command?

Actually, those two commands aren't on the server but on your client PC.