DSXchange

It is true, that when ever there are more then two tables involved we get this error in Db2 API Stage. However, this helped resolve the issue. http://www-01.ibm.com/support/docview.wss?uid=swg21455378 Creating a A new User defined Environment variable called $DS_NO_PROCESS_METADATA = 1 and setting i...

Thank you very much for posting the resolution. It worked great!!. and yes its case sensitive.

that is the beauty of Parameter sets. in the job properties you will not see the parameters. When you call them in the job they will be like #PARAMETER_SET_NAME#.#PARAMETER_NAME#. So the job properties tab are lesser. And you can change the value file accordingly to have different value file for dif...

Hello Debasis, Try removing duplicate rows and send only the one record and keep the same trigger column Col1 in your XML output stage. Else you will have to change your Trigger column to some other unique tag this way the aggregation will happen at a different level, like if you choose <main> as a ...

Thank you, That settles the case. I will load them as varchar into the tables by switching the date fields to Varchar(10).

Thank you,

a novice

Ray, Thank you for the reply. Do you mean to say that all this could be done dynamically by using RCP or do I have to individually prefix the zero for each column where it is required? What about tagged records? could that be employed to get around this? Kind of new to PX.. and curious. thank you, a...

Hello All, I have a problem where the date that we get from a source file is in format of d-mmm-yy or .. dd-mmm-yyyy format. like 1-Jan-09 the same row also contains 11-Jan-09. So how do I define the record as a date in a schema file? I am planning to use Run time column propagation from there on to...

The dba says he doesn't see any rejects or negative codes. Plus he said the transaction Isolation levels, like cursor stability to Repeatable read only are effective on Selects. Since they have the same choices in Input side, I thought there was a select done some where.. Thank you for clarifying th...

I have two parallel streams in a server job writting records to common table. The two streams have the same set of keys (Key 1,Key 2), but populate some over lapping fields (LOAD_DATE) and two stream specific fields (SRC & TGT). The problem is, lets say there are 50 records from stream 1 and 50 ...

Please post the error messages for better speculation.

thanks,

a novice

You can do multiple things.. one is when you read the file using sed replace '","' the combination of Quotes, comma and quotes to a different delimiter like ~ or tab. then you can use your field function to separate the records. Remove the remaining Quotes " etc.. or if you do not wan...

In server there is Oconv with MB Option.. in Parallel you could try using the encode/decode stages..

Thank you,

a novice

Do not do any operations on the column in Datastage transformer.. cast it as Decimal(30,24) in Oci or your source stage and propgate that value directly to orcale OCI stage.. ensure that the meta data matches. that is target also says its Decimal(30,24) or Numeric(30,24)

Thank you,

a novice

Hello, The date and time adopted by the DataStage is usually the Unix server system date time the DS server is sitting on. I found the time is now 4 to 5 hours ahead of the Unix server system date time when I logged on this morning. What is the cause and how to fix it? Regards, Tzu If you have NLS ...