DSXchange

Hi Ray,
In our situation we are not converting to a string and the target column on teh sequential file is defined as Decimal(3). Is this behavior still expected in this scenario?
Thanks - - John

Hi, We are reading in data from a Mainframe DB2 table defined as Decimal(3,0) and we are just passing this field through a transformer with the same metadata from the DB2 connector. The sequential file for this field ends up with a trailing decimal, is that expected? ex: 123. I know we can manipulat...

In the IBM support site we found teh following:
http://www-01.ibm.com/support/docview.w ... wg1JR29181

We added the Variable APT_OSL_PARAM_ESC_SQUOTE to our job and it now runs fine.

To make things more interesting when I do a view data from the paramaetrized "SQL 2"using the same values as when I execute the job I receive the correct count of: 3866987 as opposed to the 4222530 when the job is executed.

Hi, One of our app areas is tryying to parametrize part of there where clause but it does not apper to be working. I created a test job for them with 2 DB2 connectors each going to a peek stage: SQL 1: SELECT count(*) CUT FROM #ABC_ALR_CONN_DTLS.$ABC_ALR_QUALIFIER#.T1BENEFIT_PIECE A WHERE A.FIXED_VA...

Let's say we populate an existing value file with name/value pairs via some sort of a script...will a job running after this using the parameter set and value file read in the new values or does the job need to be recompiled first?

Hello, We are setting up a specific project where we are looking for dynamically writing a value file for a parameter set and having a subsequnt job(s) use these for their processing. When using Administrative variables we use $PROJDEF to insure we bring in the latest value from administrator. Is th...

Thank you both for your input. I ended up craeting a parametrized batch script on our servers with a DataStage wrapper that call this. Now both our developers and operations folks can use the dump option to view the contents of a Dataset.

Hi, I have been asked if we can use the Orchadmin command from the client machine. We have a windows environment and the application teams typically ask us to dump DataSets to text files. We are looking to see if this is something they might be able to run on their own from their client machine. Tha...

Hi,
We are currently running Version 9.1 for our DataStage environment and Version 8.7 on the BG MWB tools. Can we use the DataStage Bridge on the 8.7 environment to pullin in 9.1 DG assets or will wee need to be at least at the same version as our DataStage environment.
Thanks - - John

Hi,
RCP is not enabled for this job.

Hi, We have a simple job Row Generator ===> XFM with two output links ===> Difference Stage====>Peek Stage We gete the follwing two warnings: diff: When checking operator: Dropping component "diff_key" because of a prior component with the same name. diff: When checking operator: Dropping ...

Hi, We are attempting to decipher the different errors that we recieve on our DB2 connector stage and have a reject link. We were thinking we can demote certain warnings (i.e. Dup key) while aborting the job when a more severe errors are encountered. We tested some of this out but it appears that Da...

Thanks for all your comments. After playing around a bit it seems like all negatives "-" should be replaced with an S and all decimals for negatives replaced with a V.


PIC -9(9).9(02) should be
PIC S9(9)V9(02)


PIC 9(9).9(02) works fine since there is no sign.

Thanks - - John

The trailing or last period is standard for delimiting the cobol field definition as shown here from a piece of a copybook that was successfully imported. 05 VRUPI-NUM-XCHNG PIC 9(2). 05 VRUPI-NUM-ALC-CHNG PIC 9(2). 05 VRUPI-GIA-YTD-RMNG PIC 9(9)V99.