Search found 25 matches
- Thu Jul 28, 2011 11:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting UTF-16 file to UTF-8 using Datastage job
- Replies: 2
- Views: 3822
- Wed Jul 27, 2011 12:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting UTF-16 file to UTF-8 using Datastage job
- Replies: 2
- Views: 3822
Converting UTF-16 file to UTF-8 using Datastage job
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 (...
- Wed Sep 29, 2010 11:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading chinese data and loading in db2 tables
- Replies: 1
- Views: 1486
Re: Reading chinese data and loading in db2 tables
Hi
Try with keeping the NLS as UTF-8 and add the environmental variable DB2CODEPAGE and give the value as 1208 for the variable
Try with keeping the NLS as UTF-8 and add the environmental variable DB2CODEPAGE and give the value as 1208 for the variable
- Wed Feb 24, 2010 9:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sending multiple records as Single Message using MQ Connecto
- Replies: 3
- Views: 2205
Re: Sending multiple records as Single Message using MQ Conn
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...
- Mon Jan 25, 2010 2:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sending multiple records as Single Message using MQ Connecto
- Replies: 3
- Views: 2205
Sending multiple records as Single Message using MQ Connecto
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...
- Sun Dec 06, 2009 3:57 am
- Forum: General
- Topic: Maximum number of workflows which can be given in Parallel
- Replies: 7
- Views: 3417
- Mon Nov 30, 2009 10:02 am
- Forum: General
- Topic: Maximum number of workflows which can be given in Parallel
- Replies: 7
- Views: 3417
Re: Maximum number of workflows which can be given in Parall
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...
- Fri Aug 29, 2008 11:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Replace one or more instances of a substring
- Replies: 3
- Views: 2867
- Fri Aug 29, 2008 11:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Replace one or more instances of a substring
- Replies: 3
- Views: 2867
- Fri Aug 29, 2008 10:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Replace one or more instances of a substring
- Replies: 3
- Views: 2867
How to Replace one or more instances of a substring
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...
- Fri Aug 15, 2008 8:15 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Close Comman in ODBC Enterprise
- Replies: 1
- Views: 2526
Close Comman in ODBC Enterprise
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 ...
- Wed Jul 16, 2008 9:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NullToEmpty - Exporting nullable field without null handling
- Replies: 4
- Views: 19725
NullToEmpty - Exporting nullable field without null handling
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
Please help me remove these warnings.
Thanks, as always
- Mon Jun 23, 2008 11:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: last date of next month
- Replies: 2
- Views: 2053
last date of next month
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
Thanks, as always
- Tue May 27, 2008 2:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Proceudure from OBDC stage
- Replies: 2
- Views: 1670
- Tue May 27, 2008 10:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Proceudure from OBDC stage
- Replies: 2
- Views: 1670
Stored Proceudure from OBDC stage
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
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