DSXchange

There isn't a direct one. You could create a direct one. FUNCTION AlNum(TheString) * Returns 1 (true) if all characters are alphanumeric, 0 (false) otherwise. Ans = @TRUE CharCount = Len(TheString) For ch = 1 To CharCount Character = TheString[ch,1] If Character Match...

The default representation of NULL in a sequential file read by DataStage is "". Change this via the Null Value property on the Format tab (for the entire file) or in the Columns grid for an individual column.

Create a job sequence. In that job sequence use an Execute Command activity to run your script. Follow it with a Routine activity that invokes UtilityWarningToLog (or UtilityInfoToLog) to log any message, and a Notification activity to send email. Between the Execute Command activity and the next ac...

Since the DataStage job is the Oracle client application, the tnsnames.ora file must be correctly configured on the DataStage server machine. Also, the dsenv file on the DataStage server machine must have the Oracle environment variables correctly set.

No idea. Where are you getting your terms? DataStage does not care what you call things, but it's important that everyone in your project is "singing from the same song sheet". A rejected record may be one that fails to satisfy business rules or violates a constraint in a target database. An excepti...

Do you have any documentation about the file's structure? Does the file have column headings in its first line? The best way to create metadata for the file is to Import the Sequential File's Table Definition. This is a three step wizard; identify the file, specify its format, and define its columns...

Mod(@INROWNUM,25000) would be very efficient, but how many output links would you need? This could become unwieldy for millions of rows. And, indeed, there is a limit on the number of links that you can attach to a Transformer stage (stream input plus 127 others, if I recall correctly).

You can have as much as you like in InputArg. Put some kind of delimiter between each piece, and use the Field() function in your subroutine to parse them out. For example, the Input Values field might contain #SourcePath#|#TargetPath# SourcePath = Field(InputArg, "|", 1, 1) Target...

How is this post different from this post?

Too much detail. All you need is something like the following.

What is your "write rule" for the target database? If it's any of the "two phase" ones (insert or update, update or insert, or replace), redesign your job so that you have two separate streams (for example one for inserts only, one for updates only). You will be surprised how much quicker this is. W...

Try setting APT_PM_SHOW_PIDS to False so that you don't wait for each player process to report its startup and process ID.

Please read this post Your steps are OK. Step 1 must, of course, be a server job and step 2 must be a parallel job. The Hashed File must have a key (one or more columns); the Lookup File Set must have a key (one or more columns). What is it about your design that "doesn't work"? Are rows loaded into...

You might like to investigate the "/usr/vacpp/bin/xlC_r: not found." message returned from the shell. Perhaps the PATH set in dsenv does not include /usr/vacpp/bin ?

Set "First Line is Column Names" property to True, as I suggested earlier.

Clearly StPr is not a numeric value, and the error is reported in row #0, the first line in the file.