DSXchange

Is it also your understanding that DB2Z can only be used with BatchPipes while using DB2Z as a target stage? Not as a source?

Have you been successful in configuring another stage to use BatchPipes as a source?

Looking at the stage, it appears that the BatchPipe option is only available when using the DB2Z stage as a target.

Would anyone know how to read data from IBM's BatchPipe program?

Thanks for the confirmation. I appreciate your replies.

Two jobs controlled by a Job Sequence is the way to go, however the requirement is for concurrent load of both the file and the db table. 2 jobs would require that i process the data in the same manner twice.

Has anyone configured this stage to work with IBM's BatchPipes for z/OS?

I want to read in mulitple streams of data from BatchPipes and was curious if this stage is a viable option.

TIA

I have a question regarding job design. I am not sure i have ever seen this done in 7.x, but thought i'd ask the masses in case i am just not as well versed in DS as i think OR 8.x brings new functionality that could be leveraged. If i have a single parallel job - reads data from a database, churns ...

I have a question regarding DS and how it handles various code sets. From searching the forum, i see that DS uses UV-UTF8 as an internal code set. If NLS is enabled and I have an EBCDIC source and target with transformation in the middle, does DS convert the EBCDIC code set to UV-UTF8? If so can thi...

We are using two seperate servers for our install, one for the engine and one for services. our repository resides on a third server connected by a high speed backbone (same frame). We are also installing the 64 bit version on a 64 bit OS and hardware and have verified we meet the software and hardw...

Background: We are planning our upgrade from 7.5.1a to 8.1 and changing OS from Red Hat 3.0 to Suse 10. Our 7.5.1a install does not have NLS enabled. We are planning to install 8.1 on a seperate server and run in parallel until the install has proven out. Question(s): If we want to enable NLS on the...

use like this (u can use any name u want)RROWID = :ROWID. Since ROWID is a key word in oracle you cannot use the sameone in the job. Change it to something in ur job and it will work. Close, but what actually worked was changing the update to Manual SQL and "tricking" the SQL: WHERE (ROWI...

We are trying to use the Oracle ROWID pseudo column as the update key in an Oracle Enterprise Stage. The job does a lookup on the table which returns the ROWID of the matching record (if one exists). We added ROWID to the column list of the Oracle stage, which is set as an Upsert with an Auto-Genera...

Thanks for the enviroment variable. I'll give it a shot.

I am using the OCI stage with the Load option in DS 7.5.1a on Linux - writing to an Oracle 10g database. I have values with more than 10 decimal places. I've tried using several datatypes: Decimal, Double and text but still the digits are being lost with the Load option I've converted these numbers ...

I am using the OCI stage with the Load option in DS 7.5.1a on Linux - writing to an Oracle 10g database. I have values with more than 10 decimal places. I've tried using several datatypes: Decimal, Double and text but still the digits are being lost with the Load option I've converted these numbers ...

As I suspected (read: hoped), this is a known bug and is resolved in Fix Pack 1a. We will install the pack tomorrow and retest. Bottom line, the SCD stage should be able to handle NULLs in the comparison without kludging a special NULL transformation for each input and reference field. Let's hope Fi...