DSXchange

I think the NLS setting in Stage properties superceeds the NLS setting in Job properties

Looking for a solution for below scenario Recieving source file in UTF-16 format and need to give target file in UTF-8 format. The source file may contain double byte characters like Chinese characters I know converting the file format using unix command, but want to do that using in DataStage job (...

Hi
Try with keeping the NLS as UTF-8 and add the environmental variable DB2CODEPAGE and give the value as 1208 for the variable

I found the answer We can send multiple records in a single message using the following options in the properties tab of MQ Connector 1. Put Record Count = 0 ( this option sends all the available rows), or if you know that the number of records as constant then put that number , for example Record c...

I am trying to send multiple records as a Single Message from a sequential file to MQ Connector . I went through the documentation and tried to use 'EOL as row terminator' property in MQ connector, but found that it helps only while recieving and not to sending thru MQ Connector. I really appriciate...

chulett wrote:So what's the DataStage equivalent of an Informatica 'workflow'? Job? Node? ...

DataStage Job = Informatica Workflow

Hi All, I would like to know what is the maximum number of workflows which can be given in a Parallel Job? Is there any limit? Also, what is the maximum number of target tables we can load in a single job? Is there any limit? Thanks in advance. Regards, Deepa Answer: Looks like you are comparing wi...

sorry, I got it.!

Isn't Convert, a server function?

Can you give me the usage please, if it is parallel.

Hi all, I have a CHAR(10) field with a value of 123-456789 and I have to map this to an output field of CHAR(9) without the '-', meaning populate the outpur field with 123456789 . In server, we can do it using Change or Ereplace, but how to get this done in Parallel. Help is appreciated. Now, am I g...

Hi all, I am using ODBD enterprise stage to load the target oracle table, which invloves Inserting new records and updating the existing. Now, the user have come up with a requirement that has to Update the table with a different logic after the load is completed, Can I use the Close Command Option ...

Hi, I am wrting to a sequential file and I have a column name A - varchar(25) and it is nullable, in the transformer I have used NullToEmpty and I am still getting a warning - Exporting nullable field without null handling properties.

Please help me remove these warnings.

Thanks, as always

I have a date from the inout source and I have to calculate the last date of the next month, Is there a function or a way to get this done?

Thanks, as always

hmm..we do not have the oracle client installed on the OS

hi all,
The DBA in our shop does not allow the etl generic id to truncate the table before loading. We have to 'truncate' and load the staging tables.

Is there a way to execute a stored procedure from the ODBC stage before loading the Oracle staging tables?

Thanks