DSXchange

Of course, if you're using a BASIC Transformer stage, you could use a BASIC expression such as:

You can construct a "script" in the Administrator client's Command window containing the two DELETE.FILE commands (or DROP TABLE commands or whatever you need). The name that DataStage uses for such a script is a "paragraph". Execute the commands one at a time in the Command window. Then multi-selec...

The issue isn't really what the default is, it's whether it's compatible. You're right that the default for import/export will always be the project wide setting specified in the Administrator. And, yes, it might cause a problem if you have stage names, category names, descriptions and so on that re...

Near the top of the DSX file there is a "Character Set" property.
Change this so that either it matches what you've set on the system, or so that it's set to "English".

Already added my $0.02

The size of a dimensioned array is returned by the INMAT() function in DataStage BASIC. This returns two values (the extents of each of the two dimensions) separated by a value mark (@VM). Dimension Rainfall(3,12) Print INMAT(Rainfall) ; * prints 3}12 Dimension ColumnCollection&...

1. Is this a scalable solution? 2. Is this a performant solution? 3. Is this a manageable solution from a code maintenance point of view? 4. Is the solution tunable? 5. Is the solution utilizing the tool to its fullest processing throughput capability? 6. Is the solution utilizing the tool to its f...

If you use CREATE TABLE to create your hashed file, you can specify the pathnames of the data and dictionary portions. CREATE TABLE filename DATA pathname DICT pathname ( TYPE 18, MODULO 5, SEPARATION 8, keycol INTEGER NOT NULL PRIMARY KEY, next_col VARCHAR ... ); SET.MODE filename WRITE.CAC...

One of the services the consultants on the Forum provide is a "health check". That is, an assessment of how well you are following best practices, and probably suggestions about how things can be improved.

There are test utilities supplied with UNIX-based ODBC drivers, that you might want to ensure are included in your checklist.
Don't forget to share the results of your deliberations!

In the repository there is a table called DS_AUDIT that records the date/time and by whom each object was created, modified and deleted. Column names are case sensitive: KEY DTC CREATOR PREVDTD -- date/time deleted PREVDELETOR DTM (multi-valued) MODIFIER (multi-valued) REASON (multi-valued) In addit...

The following is how you might do it in DataStage BASIC. Error handling has been omitted for clarity. File1 is the original file, file2 contains one fewer line (the final line) than file1. File1 has been opened for sequential access on variable F1, file2 has been opened for sequential access on vari...

These customer records (?) all look different to me. The only way they can get fewer rows is to have fewer customers. This is not a good way to do business! And therein lies your explanation. If you need a more technical explanation, volume is measured in bytes, not "lines" or "rows". Sure the tags ...

The NUM function only ever returns 1 or 0 (true or false), depending on whether its argument is numeric.
You could use an expression like to replace non-numeric values with 0 without generating any warning message.

Three choices - research the Forum.

(1) BASIC SQL Client Interface (BCI) functions from BASIC code.

(2) Shell script (or BAT file) to run a sqlplus command.

(3) Call Stored Procedure through ODBC stage or OCI stage (though this does not allow for four input and four output parameters).