DSXchange

Hi all! One of the features of Informatica's PowerMart (V5.x), was the rather simple ability to create jobs en masse to quickly be able to just do a raw copy of a database to another. It was extremely limited, but suited our needs fairly well because it didn't have to be real efficient at the time. ...

Hi Paddu, To add to what Ray is saying (possibly clarification, depending on whether I'm understanding correctly or not), you may need to look at how the database engine you are using treats a question mark. In DB2 UDB, the question mark can denote a placeholder for a value being passed into a query...

I forgot to mention one thing: the sample I gave above is step 5. This is the one that I would like to be able to use just one job for and pass in parameters for the schemaname, tablename and key fields (maybe). Still tinkering with this one.

Bestest!

Hi again, OK, I've spent the last couple of hours experimenting with a couple of my jobs for one table (steps 4 and 5 from above). I was able to get the parameter substitution to work, as Craig and Kim have insisted should work even with ODBC. So, that part is not the actual problem. I was having di...

Hi all!

In preparation to closing this out, we found that we had a bug in our installation. Once we got a patch from IBM, the problem went away.

Thanks!

Hi all, I am going to go ahead and close this one out. However, the versions of the script here have already been debugged some more! There are more current and proven versions of the two scripts available to you. If you would like it, just shoot me an email and I'll forward them to you. No sense po...

In a server job the easiest approach is to build the entire record as a single field (using stage variables as needed). The Fmt() function is useful for right padding. Output metadata is a single VarChar column (since your row lengths are 30 and 32 characters respectively). I appreciate everyone's ...

1. In steps 4 & 5, I cannot seem to use parameters in the tablename portion of the user defined query. For example, one of my tables goes as follows: UPDATE UCWS.ADM_ACCT_PERIOD SET TRIGGER_STATUS = '0' WHERE UCWS.ADM_ACCT_PERIOD.SEQ_NUM = ? AND UCWS.ADM_ACCT_PERIOD.STATUS_FLAG IN (1,2) I would...

Hi all, I need to tap into the bounty of knowledge that is DSXchange :D yet again! In my current project I am transferring the data from a transactional system to a copy of the same on a different server on an iterative basis during the course of the day. Normally, I would rather do this using repli...

Do your records need to appear is a specific order; POL, INS, POL, INS and so on or can it be POL, POL, POL, INS...... ? Can you bypass the files and extract your data directly from the tables? I'm working on normal Datastage server edition not the Datastage TX. I appologize for the confusion. It i...

Yes, I have to create the target file through Datastage maps.

Is this possible?

-Regards.

Hi all, I have a requirement to generate a multi formated fixed width file from two different formatted files. Source file 1: Field1(3) Field2(8) Field3(10) Field4(2) Field5 (2) Field6(5) POL 20061031 2345623SQ 10 re 25367 Source file 2: Field1(3) Field2 (10) Field3(2) Field4(8) Field5(4) Field6(5) ...

Thanks, Kris.

I'll go dig some more.

Toodles,

Hi Craig, I have not found that stage in our installation of the Server Edition. Is it available for it? I thought it was a Parallel Server/TX stage, not Server. If it is a plug-in or something, where would we find the code for it to install? Did it come with our installation discs, or do we need to...

Hi Craig,

I've been digging around for it in the documentation. I must be missing it somehow. Do you know where in the Server Edition documentation I would find info on it?

Thanks!