DSXchange

I am not trying to violating any datastage rules I know... and I didn't say you were. And you've already done what is basically the right thing for this, post an Enhancement Request on the subject. :wink: I got it craig. I have to discuss and post these type of queries in Enhancement forum. Definet...

If rules are rules then rules for all. Perhaps in a perfect world. However, we have to live with the rules we're handed and deal with this as they work, not as we'd like them to work. Otherwise, we come off as a little... whiny. :wink: Hi Craig, I am not trying to violating any datastage rules, I j...

The DB2/UDB Enterprise stage was written to conform exactly to the rules. If you have a Char(N) data type, it must be N characters long. The DB2 API stage is essentially the server DB2 stage rewrit ... Ray, Thanks for your reply. I am totally agreed with you insense of ETL developer responsibilitie...

Hi All, Modify stage : Difficult stage in PX, insense of usability and synatx. Functions like STRING_TRIM is not trimming properly both leading and trailing spaces. I have tried all options suggested by DS gurus in this forum. Still I didn't get proper result. My wish is, if IBM will take care of th...

Hi All, If you use DB2 EE stage to extract the data or load the data, It will PAD ASCII nulls to string fields. To over come this problem, we have to set APT_STRING_PAD_CHAR as ' ' or '0x20'(ASCII equivalent spaces). But, here my concern is, Y its happening with DB2 EE stage and same thing not happe...

This kind of concatenation worked with numeric fields in another job. :? Just noticed this in the original post. Which suggests to me that the other job was a server job. Hi, The job which worked is a parallel job. But the Input Sequential file is coming from a server job. Does that make any differ...

enable "Add checkpoints so sequence is restartable on failure" option in job properties of all your subsequences and in main sequence. I think it will solve your problem.

Hi, Lets take one example for your scenario. You have 3 fileds 2 from input and 3 from reference. Input.CountryCode Input.Amount Reference.CountryCode Reference.CurrencyCode Reference.CurrencyConversionRate. Your key is CountryCode Your Logic will be like these : If Reference.CurrencyCode=(USD) Then...

Hi,

Here one thing you can do, in your design is capture the all rows in a sequential file or Dataset before you delete records in DB.

Another option is ROLLBACK your databse to get your records, based on your commit interval.

Hi, Welcome Abroad..... Have a nice experience with Dsxchange..... But, Don't forget. For any queries first use Search option and then post your query. About Certification : http://www-03.ibm.com/certify/certs/iisdwsdev75.shtml http://blogs.ittoolbox.com/bi/websphere/archives/datastage-certification...

Hi,

First create a dummy column as sequence number and Use nextval function to create DB sequence and concatenate this with your sequential file. Is this your requirement ? If not, let us know your flow.

we are using lookup stage Please provide the full details, then only you will benefit from DSxchange. If you are using lookup, which version you are using. If it is 7.5.1, the check the datatype of both input and reference link. Both should be the same and check the condition for look up failure, w...

Hi, Here the problem is, your using a CHAR as a Key column and your checking the case sensitive or insensitive. Just check the key fields and select the option case sensitive and try out the result. Your key has a unspecific format. Just check the datatype and select the option of Case sensitive. W...

Nagesh, thank you for your response. I am not clear about what you mean by "The job sequence( Server and Parallel) still uses the Basic routines". I guess you mean by the Routine Activity stage, right? Also, in a job sequencer, if I have JobA and JobB and After-job subroutine for JobA fai...

Hi,

Here the problem is, your using a CHAR as a Key column and your checking the case sensitive or insensitive. Just check the key fields and select the option case sensitive and try out the result. Your key has a unspecific format. Just check the datatype and select the option of Case sensitive.