DSXchange

Hi, We have a job of the following type OEE => Lookup => Transformer => Upsert (update only) => Reject || V Rejects Inserted The final upsert stage was rejecting records during update. For some the SQLCODE was -1480. For some, it was blank We tried using APT_STRING_PADCHAR values of 0x0, 0x00 (no im...

Yes, that's what we have done.

Just wanted to check if it is possible in column generator thereby avoiding use of transformer.

Hi, I need to generate 2 columns of type timestamp and add them to input data stream. The value of the timestamp fields should be current timestamp. Does column generator provide a Generator type to create current timestamp? For dates, it does provide an option of 'use current date'. I see no simila...

I did check the file.
THere is only one variable (NMEMOFF) related to NLS in the file. I am not sure if this indicates that NLS is enabled.

Hi,

We have checked the NLS settings for source and target database and these are the same.
Therefore, the issue seems to be with DS NLS settings itself.

We have asked the Admin to provide details of the NLS setup as these are not accesible to us.

Will post them as and when we get updates.

Hi,

As per the parjdev pdf, if NLS is enabled, the NLS Map tab will be available. I do not see this tab.

Are there any default NLS settings? Where can I obtain the information about this?

I have checked in Admin and the NLS settings are disabled for viewing for developers.

Hi,

I see this issue has been raised before.
I have the same issue and I have used User defined sql.

Should I start a new thread for this or can we continue here?

Hi, We have a partitioned table, where each partition is loaded via a separate file. The number of partitions are dynamically created based on source and hence the number of files can vary from month to month Naturally, we can load these files in parallel. TIll now, we were using sqlldr, unix and PL...

For <tag/>, there is an option in the XML output stage itself which lets you choose the format you desire for closing tags. For your second requirement, unfortunately, XML stages do not allow multiple repeating tags at the same level. So, you will need to create dummy tags to put the repeating tags ...

Thanks for the reply Kumar. The data that I need to delete is not 50% of the table but it still causes the transaction log to overflow. Deleting chunks with loops seems the preferred approach. Could you please explain what you mean by "delete on some chunk with help of loop in SP. " ? Am n...

What are the options when you want to delete based on a key, say date, and not truncate the entire table? Selecting the rows from the database first and then using the keys to delete is one. But wouldn't that lead to select of millions of rows from the table, landing to a dataset and then firing the...

One way of using a common null value for all fields is to read the fields as Varchar instead of char. Later in the job you can turn them back to Char.

Are there no other messages in the log?
What is the aggregation type that you are using in the aggregator?

The value of the input field is 5000. I have tried the function with "fix_zero". But it still does not work.

I have an input column(BIGINT). I am using DecimalToString on this column and writing it to output (VARCHAR(20)). However, the output field is populated with empty string. I have tried converting the input column to a decimal and then using the function but it still outputs an empty string. The synt...