Search found 238 matches
- Mon Aug 13, 2012 2:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQ and Server Shared container
- Replies: 7
- Views: 4813
MQ and Server Shared container
I have a job design like MQ--Transformer--Server Shared Container(with Folder Stage in it). I am reading around 4 messages from MQ at a time and creating each XML for each message and storing in a FOlder stage. each xml is of around 1.2 MB size. I increade the APT_DEFAULT_TRASPORT_BLOCK_SIZE to high...
- Tue Oct 26, 2010 10:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: UTF-16
- Replies: 3
- Views: 2217
Thanks Ray, In the job i am producing lot of other Files too. I just wanted one File alone in UTF-16 Format. If i change the setting of NLS in the job properties level to be in UTF-16 then all the other files i am producing would be in UTF-16 format. Is there a way that we can do the change in one s...
- Mon Oct 25, 2010 3:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: UTF-16
- Replies: 3
- Views: 2217
UTF-16
Hello
I need to produce the sequentla File in UTF-16 Format. I have only one Field which i am mapping from oracle to Seqfile.
Default Project NLS is defined as ISO-8859-1
Please help me on this
I need to produce the sequentla File in UTF-16 Format. I have only one Field which i am mapping from oracle to Seqfile.
Default Project NLS is defined as ISO-8859-1
Please help me on this
- Wed Sep 15, 2010 4:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: logic on group number
- Replies: 6
- Views: 2792
- Wed Sep 15, 2010 3:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: logic on group number
- Replies: 6
- Views: 2792
- Wed Sep 15, 2010 2:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: logic on group number
- Replies: 6
- Views: 2792
logic on group number
Hello I have a requirement where i need to read the data from seq file and write it to a seq file. i am using transformer and running the transformer sequentially. I am using a job parameter called group number. If the group number is 4 then i need to create additional column called group number and...
- Thu Aug 26, 2010 3:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading Self referencing table
- Replies: 3
- Views: 3252
Loading Self referencing table
Hello
I am loading self referecing data into table.
i.e i have Col1 and Col2 and couple of other fields. Col2 is a foreign key to the col1 which is PK.
When i try to laod my data is geting rejected because of FK vilation (sqlcode:-2291).
Is there a mechanisam tht this can be done.
Thanks
I am loading self referecing data into table.
i.e i have Col1 and Col2 and couple of other fields. Col2 is a foreign key to the col1 which is PK.
When i try to laod my data is geting rejected because of FK vilation (sqlcode:-2291).
Is there a mechanisam tht this can be done.
Thanks
- Wed Jul 28, 2010 7:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Security Dilemma
- Replies: 2
- Views: 2127
All the other projects (A,B,C) uses the same id for day today activities. Thanks all for your reply. I got a plan But I not sure whether this come out good or not. Please advise Step 1: Create a user like dsadm. For example let the user name be demadm for project D Step 2: Grant all access to demadm...
- Fri Jul 02, 2010 8:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hardcoded values in transformer stage
- Replies: 5
- Views: 3765
- Fri Jul 02, 2010 3:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hardcoded values in transformer stage
- Replies: 5
- Views: 3765
Hardcoded values in transformer stage
Hi All,
Iam analysing one of the job in that i have seen the value for one column hardcoded as '$1'.
Can someone tell me which value it refers to '$1' if we hardcode in transformer.
Iam analysing one of the job in that i have seen the value for one column hardcoded as '$1'.
Can someone tell me which value it refers to '$1' if we hardcode in transformer.
- Thu Jun 10, 2010 6:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset
- Replies: 11
- Views: 4238
- Thu Jun 10, 2010 5:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset
- Replies: 11
- Views: 4238
Dataset
Hi all, Can anyone tell me what are files created when we create a Dataset and their locations? And i searched in this forum then i came to know descriptor file and control file will be created for each dataset. Whichfile will be created in Resource disk path? And where will be actual data stored?
- Mon May 17, 2010 7:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Running through CLI
- Replies: 2
- Views: 2124
Running through CLI
Is there any command to run jobs through CLI.
Thanks
Thanks
- Sat Apr 10, 2010 9:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Purpose of Dsparams.keep
- Replies: 2
- Views: 1898
Purpose of Dsparams.keep
Hi all,
I want to copy user Defined variables from one project to another project .I searched in and i found i need to copy DSParams file to another project.
Can anyone tell me that i need to copy DSParams.keep also to that project ?
I want to copy user Defined variables from one project to another project .I searched in and i found i need to copy DSParams file to another project.
Can anyone tell me that i need to copy DSParams.keep also to that project ?
- Sat Apr 10, 2010 8:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Difference between $ENV and $PROJDEF
- Replies: 5
- Views: 5692