DSXchange

If you want to add a string to a filename in a DataStage job, then you would need to use a job parameter; you can compute the date in a job sequence calling that job and pass in the date as one of your parameters.

This code takes fields 1-4 of string Merge_Out.CRC_ROW as delimited by value of the character in RowDelim and then trims all blanks from the beginning and end of the string. for example, if RowDelim is the semicolon character ";" then if Merge_Out.CRC_ROW = " Hello;there;Fellow;DSXcha...

The process of turning a string number or integer into a packed field is mathematically simple, but best done using the complex flat file stage as Ray has suggested. If you really want to do the math yourself it would be simplest to use a server job and a short BASIC routine, as the functions to per...

It would be extremely helpful if you would also post your SQL.

DataStage itself does not do this, it is an operating-system level command. You would need to call an external shell script or command in order to do this, but if authentification exists between the computers it is a simple command call.

Can you use the web interface to Websphere? (http://ibminfosphere.hcl.com:8080)

I declared 2 columns and then added a Job Parameter SequenceName and then edited your SELECT to read "SELECT DS_JOBS.NAME, DS_JOBOBJECTS.NAME FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.NAME = '#SequenceName#' AND DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO AND DS_JOBOBJECTS.OBJTYPE = 'J' AND DS_JOBOBJ...

How have you declared your routine, "ParsenExtract" (is that spelling correct?); is it in your own .dll or custom routine definition?

No, you misunderstand the message. Depending upon your flavour of UNIX, the command you need to issue is "swap -l"

The basic approach you chose by calling the script via the execute command stage is the correct method. But you aren't interpreting the returned string correctly - most likely due to extraneous new line character(s). Output your returned value to the log file to see what you've got. p.s. Any post ma...

Does only 1 row go through this transform stage, or do you need to emulate logic "if any 1 row is INVALID then set user status to invalid, otherwise leave result as valid"?

Does that mean that the exception handler is working in other jobs but not in this one, or that the mail activity in general is working?

Could you post the exact error message and exact (using cut-and-paste) use of the parameter in your job?

No significant downside and no difference at Version 8.1 to the former version. You will have to ensure that you don't write a VarChar value that is longer than the target (e.g. an Oracle table) can contain, but using unterminated VarChar columns within DataStage jobs is not a problem - in fact it i...

In server your date columns are either in internal format or in display format. The internal formats are numeric and thus you can subtract one from another and the resultant integer is the difference in days between the two dates. If your dates are in string format, you would need to convert them to...