DSXchange

If you try math on a NULL value, you'll get an Abnormal Termination. Consider any of these options: If ISNULL(link.column) OR NOT(NUM(link.column)) Then 0 Else link.column * 1 If ISNULL(link.column) OR NOT(NUM(link.column)) Then 0 Else link.column + 0 ...

Thanks for helping make this site successful!

Run a shell command (DSExecute API) and use the "env" command and parse the screen output.

Since no one responded to this post, I am interested in hearing about experiences with Sybase IQ working with PX. How is the partitioning done on a table? Is a parallel read with divide and conquer method being used on a "SELECT * FROM table" type query?

Can you post a sample row where your logic doesn't work? If your job is directly feeding into an ODBC stage, I suggest branch a second output link to a Sequential file stage and not use the DateGeneric... functions to see what is being parsed. I would have written it like: If TRIM(FIELD(lnk_...

Everything you described won't work. If you have two transformer stages connected like this: ---->XFM1---->XFM2 then rows move between the stages, either one at a time or in blocks depending on if there is row buffering or inter-processing selected. An after routine only runs when the last row goes ...

From Designer Guide section 8-3 Administrating Templates To delete a template, start the Job-From-Template Assistant and select the template. Click the Delete button. Use the same procedure to select and delete empty categories. The Assistant stores all the templates you create in the directory you ...

Templates are not jobs, they're templates. They don't reside in DataStage, they reside on a users client PC. This is why I don't recommend using this feature. One option is a Windoze network folder that everyone specifies to use to hold templates.

Knowing nothing about your mainframe environment, there are some options: 1. Have the mainframe FTP push the file to a server. 2. Have a process FTP pull the file to a server. 3. If you have DB2 mainframe setup, put the file into a mainframe table and use DB2 connect with a DB2/UDB server act as the...

Methinks it's time to talk to a DBA (which means Don't Bother Asking)

what is the difference between DSU and without DSU? Functions need a declaration, but DSExecute is a Routine and therefore CALL'ed. Custom functions using other custom functions or job control API functions need the INCLUDE and DEFFUN statements. Custom subroutines are actually saved with a "DSU." ...

When I attempted to connect to the database through the Datastage Manager I got the following error DATABASE Attribute not found (DSCMDGetAttrIndexByName) It happened only once. Not sure if that leads us to anywhere? Well, this certainly is a clue that something is messed up. Either your Ma...

Just to recap, DS doesn't honor synonyms when importing metadata. You have to choose the schema where the table lives. Since it's Oracle, you have to deal with "roles" as well, maybe something is different there?

Oops, I corrected the original post, you don't need the INCLUDE statement you added as well.

Then you have to do what Craig suggests.