DSXchange

Yuo don't need ereplace, just convert. Ereplace functionality replaces one string with another and isn't required here.

Create an output link to a text file in that job, then check for the file contents from the sequence.

ftp connections to host systems usually need more (and different) parameters than merely giving the name, userid, password and file. Can you connect to the host from the command line FTP program on your DataStage server?

I can't recall all the steps and settings offhand, but at least your environment values look better. What is the error in the logfile?

I just created a test job. Row Generator generates a VarChar(200) column called "InCol", the modify stage creates a column defined as VarChar(100) with a derivation of "OutCol:string[max=100]=substring[0,99 (InCol)" and get a warning of Row_Generator_0: When checking operator: When binding output in...

convert(char(10),'',In.String)

Your PATH and LD_LIBRARY_PATH are missing all of the settings usually added by sourcing the "dsenv" script; where did you check these? The first line of the direcotr log file of a job run will show you the environment settings that were used, so perhaps instead of "view data" you can compile and run...

The patch we needed was only applicable to V8 Parameter Sets and does not apply to normal parameters.

I should have caught that. I just looked at the error message, not the red text to see what actually caused it. I need glasses...

Try

Add
MailCommand = "From:":FROM_MAILID:"\nTo:":TO_MAILID:"\nSubject:":SUBJECT:"\nBody:"

and then PRINT or Call DSLogInfo() of the MailCommand variable. What do you get?

throbinson - thanks, I felt like I was missing something when I posted that but couldn't check it with a job and just "let it slide". Good catch.

I can understand how you can get an error disabling constraints, but not with indices. If you enable logging and run the job, what error do you see in the log file?

... i.e. A variable called DSN=Dev_Example does not automatically get updated to DSN=Test_Example. How could DataStage know which values to use unless you tell the application what values to use. These environment variable values are stored in the text file called "DSParams", each project has its o...

Parallel jobs are designed to maximize throughput. Because of the relative complexity of process interaction in PX jobs, the startup time needed in order to get everything sychronized in a "ready" state is going to take quite some time; the more nodes you declare in your APT_CONFIG file and the less...