DSXchange

ray.wurlod

Not easily using a Sequential File stage. Only one record format is permitted. You can use multiple Sequential File stages each writing one record format then assemble the resultant files into one with a cat command. Or you could specify the table definition for the Sequential File as a single, larg...

ray.wurlod

So what, precisely, is the problem that you are having? Is the metadata on each output one of the redefined table definitions? Are you getting any error messages logged by the CFF stage? If so, please post the exact text.

ray.wurlod

The Sequential File stage reads a line at a time. You would typically pass this line into a Transformer stage and have as many outputs from that as there are different line types. You can derive whatever data you derive from each input line on its own output link. And then send them wherever you wil...

ray.wurlod

Or you can use the fact that DataStage can treat a directory as a table in which the file names are the keys.

Code: Select all

OpenPath directory_path To file_variable
Then
   Select file_variable To 10
   ReadList Ans From 10 Else Ans = ""
End
Close file_variable

ray.wurlod

Who's on first? (Don't go there.) For younger participants and those who haven't been exposed to the great radio comedies of the 1930s, that quote is a line from an excellent and hilarious comedy duo called Abbott and Costello. There are still some around who can do the whole thing. You can probably...

ray.wurlod

Neither Iconv nor Oconv work with timestamps. You must first separate the date and time components, and convert them (if needed) separately.

Timestamps in ISO 8601 format (YYYY-MM-DD HH:MM:SS) can be compared accurately as strings.

ray.wurlod

I can only ask "what changed?" - not only in QS but also on the system(s).

ray.wurlod

What I actually said was "uninstall SP2 OR get the patch". Small semantic difference!

ray.wurlod

Try setting the NLS map (at least on the Sequential File stage) to NONE, then using the ASCII function, or one/some of the SDK utility functions, to effect the conversions.

ray.wurlod

This isn't the VOC any more. Now it's the fact that there are I-descriptors (called $DUMMY1 and $DUMMY2) in the file dictionary of APRECON.HIST but these I-descriptors are not in a compiled state. Use the COMPILE.DICT (or CD) command in UniVerse to compile them.

ray.wurlod

Check in the Data directory of your project. Are they there? Have you changed your run profile, such that you're specifying a different master project directory pathname?

ray.wurlod

The DataStage server is only a server to the DataStage clients. At run time it is a client to the database servers to which jobs connect.

ray.wurlod

Yes. There is a paper on that very topic at Information on Demand 2006 conference.

ray.wurlod

ray.wurlod

To read the file specify #$DSLOGDIR#/#JOBNAME#.detail in the Filename property.

Do whatever you like with its rows in the job design. Multiple output files requires multiple output links, probably from a Transformer stage.

Search found 53125 matches