DSXchange

Thanks Dean and Craig, Marking this to closed.

Krish

deanwalker wrote:No, it is not.

Hi Craig,

Hope the No is for version 8 and not for the platform H-PUX.Can i mark this closed ?

Thanks Krish

Hi,

I have done the installation of NLS in maintenance mode after installing the DS 7.5.2 on AIX platform. Just wanted to confirm whether the same is feasible with version 8 on HP-UX platform.

Thanks for reading,
Krish

Hi, When i try reading/ writing using the db2 ese stage which connects to a db2 9.1 database on the same IBM P-series box as my DataStage server, i get this error. Fatal Error: APT_DB2Utils::dbversion:unrecognized version string: `SQL09010'. I have specified the db2 server and database name in the e...

Thanks everyone for your inputs...I have added CRC of such long columns with 4000 characters and also i have such columns as non keys in the hash files and the job works fine now..

Thank you!
Krish

Hi, My job design is reading records from a oracle 9i OCI stage and have a look up with hash file( which has one columns with 2000 characters long and the number of key columns is around 40) and writes to seq file. Only look up operation is done with hash file in the transformer stage. HF(hash file)...

Hi, am posting this after searching a couple of pages for this topic. I could nt find one..am sure this could be a repetitive topic..if yes pls provide me with that link. Question --------- I need to do lookup with some millions of rows in oracle table in OCI stage. I can choose creating a hash file...

Hi, I just went through the Orchestrate User Guide and OperatorRef pdf files. I found that almost each and every active processing stage in a parallel job contains an associated operator. Does that mean that when we execute a parallel job, the entire job design is converted into a set of Orchestrate...

Would like to add this to my above requirement...After reading the xml file and applying the business rules i need to load the data into db2 tables on AIX.

Thanks
Krish

Hi, Would like to know whether it is possible to apply simple business rules like Alphanum check/If Else logic while reading from a xml file. I know that these business rules can be incorporated using a parallel transformer, but am not too sure whether i can use parallel transformer for this. Also i...

Hi, I got to know from the previous postings by Rhys Jones that it is not possible to connect to Db2 databases on OS 390 machine using DB2 EE stage. Since am looking at doing the extraction of records from different partitions in parallel, Does that mean that it is not possible to extract records in...

Processing is already happening in parallel in my 8 nodes, am looking forward to do the extraction of records in parallel. Considerable amount of time could be saved if i could do the extraction of records on multiple nodes. Also the fact that the no of records fetched by the db2 stage in parallel e...

Db2 enterprise stage is not recommended to be used for non unix databases. As i already mentioned my db2 database resides on a OS 390 machine.

Thanks
Krish

Hi, This is my job design DB2 API--> Parallel Tx--> Seq file. I have a parallel job to extract records from a db2 db on OS/390. I use DB2 UDB API stage which is the recommended one for non unix databases like mainframes. My db2 table is partitioned and the first partition contains around 2 million r...

Hi Ray,

I created C routines to implement business rules when i designed parallel jobs. Can u pls tell me hw to invoke the C routines in mainframe jobs?

Thanks
Krish