DSXchange

Do an exact search on 'px routines'. One example is this

The news channel caught my attention while i was typing

Modularization, Restartability.

Usually companies which use CD as a source of transfering files, have a standard script in place. Get in touch with the connect direct folks to help you get a standard script. Execute, test it from command line. You can then fire that script from DSExecute() or before/after job/stage subroutine (Exe...

Welcome Aboard
Search for the keywords 'IPC stage'. You will find dozens of posts. Go through them and you will have a very good idea of what that stage is.

use TimeStampToString(DSJOBTIMESTAMP,"%yyyy-%mm-%dd %hh:%nn:%ss") in the transformer, that would help Thats a px function and of no use in a server job. prmuttireddy, how did you change the date field to timestamp. Changing just in DataStage is not enough. YOu have to change it in the database tabl...

Ray is right. It surely is permissions. Check out this on IBM's help.Scroll down untill you see explanation for SQL3508N.

Have a second job that does the truncate. Or you can have a small stored procedure and call that stored procedure in the second job. Keep them seperate.

It will only be for your id for that particular terminal only. Do this

You love doing that, dont you Ray ?

A pipe delimited would automatically mean that its not fixed. A fixed width file has no delimiter, just that every column's length is defined and the values are picked based upon that column length.

By the command dsrecords mydataset.ds. For more info check this post.

Yes. Count and DCOUNT both will work. You need to read your row as a single column and something like DCOUNT(in.Link,"|") = x in contraint where x is the number of pipes your looking for.

Yes this website.
Jokes apart, what exact message were you referring too. I doubt any error message that the DSEngine can produce, has not been discussed here. Usually there are surrounding warning messages that aid in understanding the fatal message.

Yes Mr. Whale it will. Any stage thats fired in parallel will be waited upon to finish before moving forward
Go ahead, test it for yourself.