DSXchange

This shouldn't be a problem. DB2 Connect to an AS/400 via the DB2 plugin and output to SQL Server with the ODBC stage shouldn't be a problem. The biggest problem I had was configuring DB2 Connect to the AS/400 was setting the CurrentPackageSet and schema list. If you don't limit the result from the ...

This shouldn't be a problem. DB2 Connect to an AS/400 via the DB2 plugin and output to SQL Server with the ODBC stage shouldn't be a problem. The biggest problem I had was configuring DB2 Connect to the AS/400 was setting the CurrentPackageSet and schema list. If you don't limit the result from the ...

Hello, could anyone provide me with recommendations with the following problem. I have two tables, parent and child, child table as a reference, writing into a third target table. One of the business logic I need to incorporate is to capture a new record from the child table and insert this record i...

Is the DataStage Look Up stage only availabe if you purchase the parallel extender?

Thank you in advnace.

Thanks Roy. Yes, I've already thought about implementing a job the way you indicated. However, initial results will contain several values which need to be plug into the same variable as a parameter for the second stored procedure., when I call it. -i.e., result set for parameter [99, 90, 12, 28] ca...

Hi, can anyone tell me if it is possible to pass a variable from a stored procedure to a DB2 stage? What I'm trying to do is call a stored procedure, obtain the result set then pass variables from the result set as parameters to the next stage (DB2) to execute another stored procedure. Thank you in ...

Has anyone used DataStage's 390 JCL templates with Endeavor? The company I work for will not allow the execution of non-Endeavor JCL's to compile & link. I'm trying to get information on the how difficult it is to pass DS JCL parameters to Endeavor. Also, there is a xtrn_loop within the JCL temp...