DSXchange

ISO 8601 prescribes the format of a timestamp.

If your timestamps conform to this format, then you don't need to to anything other than compare them with a ">" operator.

Welcome aboard.

Up to date information is usually to be found from the IBM Information Center

Check the name of the DataStage macro. I think it's actually DSJobStartTimestamp.

Note, too, that DataStage macro names are case sensitive.

Try this approach. Read the entire file before the loop. Convert the line terminators into, say, pipe characters and use that to delimit your "list of things" loop. Within the loop use Field() functions to parse the comma-delimited lines. ExecuteCommand: cat #filename# | tr '\n' '|' StartL...

"Not a runnable job" can not stem from any uvconfig parameter; that it's occurring after uvconfig changes that increase values not too extremely (I assume you also ran uvregen) is just coincidence. Not a runnable job is typically about job status - the job has aborted, crashed or has not b...

mouthou wrote:sequences are not allowed

Resist stupid requirements!

Format your code. The error will jump out at you. But please post the formatted code anyway, so that others may learn.

Why?
The file is being read one line at a time (allegedly).

the things which I want to do are get the server name ODS15LP05 from service tier ods15lp05.boulder.ds.com:9080

Am I missing something here? The server name (that is, the host name of the services tier) IS ods15lp05 surely?

Derivations (assuming source is read as single VarChar):

No. That's why I specified single VarChar with optional downstream reparsing.

You don't have to assume anything. The score tells you that the op1 operator (the Column Input stage - which is combined in the same process as the Copy operator (the Copy stage)) - executes in parallel. Check the monitor to determine CPU consumption. Though I doubt that a Copy stage acting as a sin...

The easiest way to to grab the first 10 characters with a Left() function or substring operator.

Another way is to use a Field() function to grab just the first field (probably identifying space as the delimiter).

Transformer stage with three outputs, each outputting a single VarChar column. Funnel to bring them together. Add an identity column to each output and use Sort Funnel to keep them together. Parse downstream if required.

if any inone still facing the issue, can add below two environement without pre-fixing $ to variable in user defined enviorment variable APT_CONFIG_FILE=C:/Ascential/DataStage/Configurations/2Node.apt APT_ORCHHOME=C:/Ascential/DataStage/PXEngine steps 1- goto control pannel ->system propertise -> a...