DSXchange

I don't think you can do it with properties. You can read the entire record as a VarChar, parsing it subsequently using a Transformer stage.

Is this your own (user-written) job control routine, or was it created using a Batch or a Job Sequence?

If it's your own, then you use the CALL statement to invoke a BASIC subroutine. You must know the BASIC subroutine's Catalog name (typically the subroutine name with a "DSU." prefix).

Getting it is the easy part. Read the help for the DSGetLinkInfo() function. What do you want to do with it once you have it?

Perform the calculation, then convert the decimal number to a string. You can use the Right() function to extract the relevant number of characters from the right-hand end.

Start with the job that compiles. Add bits to it until it doesn't compile. Figure out what the problem is with the most recently-added bit.

hhh wrote:Is there any environment variable so we can eliminate such kind of warning message.

No.

You can right-click on the message itself and create a local message handler.

Welcome aboard. :D
You would be far better off converting the NULL to "" within the job design. There is a built-in Transform called NullToEmpty exactly for that purpose.

Have you tried using user-defined SQL? Have you tried using a database sequence in the manner you describe? The important thing, if you do, is NOT to provide a value from DataStage for that particular column; the number of columns in the DataStage job must exactly match the number of parameter marke...

There's no need to involve the intermediate file(s) mentioned by Arnd; you still need to use a Transformer stage to parse the individual lines. Alternatively you could use a filter command such as sed or awk or tr to translate the delimiter characters prior to the lines being processed by DataStage....

You can have multiple stages (except investigation stages) in a job, but that's about all there is for sequencing in QualityStage alone. You could, of course, involve DataStage to get your sequencing, using the QS plug-in but, as others have noted, this is not the world's friendliest interface. Or y...

It's reporting that your Wrapper stage finishes successfully. I guess it's a warning because the framework does not expect to find Wrapper stages, and so marks it as "unusual". Use a Message Handler to demote the warning to an informational message.

Welcome aboard. :D It would appear that you have a switch enabled in your shell that reports argument substitutions. If you can find out what this switch is, disabling it ought to remove the message. Type CMD /? to find out more about shell switches. You might also like to try using %1 rather than &...

Welcome aboard. :D It would appear that you have a switch enabled in your shell that reports argument substitutions. If you can find out what this switch is, disabling it ought to remove the message. Type CMD /? to find out more about shell switches. You might also like to try using %1 rather than &...

See if you can sweet talk your vendor into providing a copy, perhaps with a time-limited licence. There is no other legal way to obtain a copy of the software. The software itself comes with the usual manuals, but the only "tutorial" therein is the "getting started" chapter. You would need to enrol ...

Doesn't the Oracle Enterprise stage do this automatically? It ought to. IMHO, of course.