DSXchange

Hi, The full ANSI makes clear what part is the join defining the result set and waht part filters/prevents rows from being returned in that result set. What Vincent was refering to as incorect results is with outer joins; most DBs won't give corect results for left/right outer joins when you put a "...

Hi,
A production system is not suposed to be in this situation to begin with anyway, so why do you need this?

Hi, No Stage will work ! You need to define the logic for parsing this row and write a basic routine to do it. Unlees you have some other logic, like each row is exactly 80 characters then you can use the existing fold function to generate several rows from the one you read. It seems that you need t...

Hi, This was covered before, search for it. In short: dsenv is the file to define env variables, it gets loaded when the dsrpcd process comes up. having encripted env var will require a way to decript it! You can use tables/files/hash files or encripted parameters to minimize exposure of such info. ...

We are currently trying to see if adding swap space helps.
I'll post if the issue reoccurs.

Hi,
to add on what ray said.
If you must and I do say must use a SP then any dummy row you can generate via a transformer stage could be used to send a user defiined sql invoking the SP.

IHTH,

Hi,
From the readme file:

Version Control 7.5 provides continued support for component modifications
within the DataStage 7.5 release, including PX Runtime Message Handling and
enhancements to Job Sequences.

IHTH,

Double post Please answer the other one!
http://www.dsxchange.com/viewtopic.php?t=93979

Hi,
The most probable reason would be you didn't get the privilages required on the production DB as you have on the test DB.
IHTH,

Ok your like the 10th person to mistake me for Ray! As flattered as I may be and as willing to give Ray any credit I'm not him I've got several private messages the past month or so again from people mistaking me for Ray, so let me just clear it up before anyone else makes this mistake I'm Roy not R...

Hi, Usually I'd asume the table definition doesn't have the PK checked for any column in your case; is it? Or perhaps a change in scheme ? Performing a "select * ... " is a perfect way to have jobs fail along time due to scheme changes. It might also have something to do with the fact that 7.5.1 has...

Hi, If my memory serves me this routine is for getting job info for jobs that were run using the supplied routine UtilityRunJob under sdk\Utility in your repository window. taking a peek on that routine should shed light on using the one you mentioned. It will also give you some insight as to buildi...

Hi, Open the online help of the designer and type macro. In the page there are 2 blue links click on the top one. This will show you several macros that hold info similar to what you can get with the DSGetJobInfo routine and exists foreach job while it it running. In your case you can simply use DSJ...

Hi,
the max value you can use for array size in cases like this is 8192/number of columns.
some times you still need to reduce 1 or 2 from the result and your fine.

IHTH,

odbc.ini. ------------------- [DB2 Wire Protocol] Driver=/opt/Ascential/DataStage/branded_odbc/lib/VMdb219.so Description=DataDirect 4.20 DB2 Wire Protocol Driver AddStringToCreateTable= AlternateID= #Collection=OS/390 and AS/400 (Remove for DB2 UDB)#//commented Database=SRCDB (Remove for OS/390 an...