DSXchange

We are adding a new db2 database, modeling our file entries after an existing database with minor changes. DBX0 is the new db id. After making changes in these two files, we try doing a BIND using the stmt bind22 dbx0 and received the msg "Package creation failed!: Remote Database Not Found: DB...

the data used to populate the temp table is on another platform/server so building the temp table in the BEFORE tab would not work, right?

I want to build a temp table and then use that temp table to JOIN with another DB2 table. Can this be done? I have seen other posts where its mentioned that it can be done in a UNIX script. This would not help me, since I don't know UNIX. I have built the temp table, but I think it is going away bef...

Is there a known problem with the report generator? I have a job that accesses a db2 table and I let DS generate the SQL. Everything looks fine in the stage itself, but when I generate the report for this job, it shows a whole different SQL stmt.

Start by thinking about how you'd do it in SQL. A UNION, maybe? Then, essentially, replicate that methodology in DataStage. Probably the easiest is to have DataStage execute the SQL you got in the fi ... I started out that route, but then realized that the two tables are on different platforms/serv...

We have a driver table (db2) containing an old part nbr and a new part nbr (a cross-reference). On this table, the old part nbr is not unique, so we could have two rows on the table with the same old part nbr, but two different new part nbrs. On a second table, we want to match on the old part nbr a...

We are building a front-end app that will be used to capture info needed to drive our DS process. The info will be stored in DB2 tables on the mainframe. Does anyone have expereince using a front-end app to start a DS job, so that the user does not actually have to sign-in to DS? Is this possible? W...

how do you "import" db2 table definitions from a mainframe?

We have a job that is trying to access db2 on an IBM mainframe and when we execute the job we receive the following error - ds_loadlibrary: error in dlopen. Please be specific in your replies since I am tech. challenged. This was a test job written to test the installation of DS.

I want to access an MS Access db that resides on the C drive in a folder. Where do we tell ds what folder to access this db? Please be specific, 'cause I am learning this as I go.

Has anyone built a front-end app to DataStage? An app that would let a user enter job parms and submit the job without having to actually sign on to ds.