Search found 45 matches
- Thu Jan 16, 2014 7:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORA-01555: snapshot too old
- Replies: 1
- Views: 2825
ORA-01555: snapshot too old
Hi I got the following error while extracting data from a table and insering in to the hash file. in Select statement we have 7 fields. while creating hash file we are keeping 6 fields as a key column. Kindly give me your valuable suggestions to fix the job. LkFBLk..FormatKey: ORA-12801: error signa...
- Wed Oct 17, 2012 5:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: input file data sort order and output file data order
- Replies: 3
- Views: 1785
input file data sort order and output file data order
Hi, We have observed below data order in the data when it is written to output file. This is a server job. Could anyone please explain. We have input data order as mentioned below. ID|NAME 1|A 2|B 3|C 4|D Job is very simple and no contraints involved. In output file, the data order should be same as...
- Thu Mar 31, 2011 7:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Split a record into multiple records
- Replies: 8
- Views: 6707
Split a record into multiple records
Hi,
I have a requirement as mentioned below. I need to split one record into multiple columns as shown below.
Input Record
---------------
Col1
a,b,c,d
d,e
f,g,h
Col1|Col2|Col3|Col4
a|b|c|d
d|e
f|g|h
Could anyone help me out on the above.
Thanks in advance.
Regards,
Raj
I have a requirement as mentioned below. I need to split one record into multiple columns as shown below.
Input Record
---------------
Col1
a,b,c,d
d,e
f,g,h
Col1|Col2|Col3|Col4
a|b|c|d
d|e
f|g|h
Could anyone help me out on the above.
Thanks in advance.
Regards,
Raj
- Tue Sep 15, 2009 4:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion in 8.1
- Replies: 1
- Views: 1723
Date conversion in 8.1
Hi,
I have a requirement. I have to add 91 days for the below date format. Output also should remain same.
Input--> January 6, 2008
I went through the forum, but I am not successful.
Can anybody suggest the solution.
Thanks.
I have a requirement. I have to add 91 days for the below date format. Output also should remain same.
Input--> January 6, 2008
I went through the forum, but I am not successful.
Can anybody suggest the solution.
Thanks.
- Mon Jun 15, 2009 5:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal Termination of Stage
- Replies: 4
- Views: 2931
Abnormal Termination of Stage
Hi, I am trying to run a job but this is aborting with error in the log "Abnormal termination of stage ********** detected. I reset the job and see the same error without much help. Error: "Abnormal termination of stage LoadsCausalStageSchema..Xfm detected" Job Design: Iam loading dat...
- Wed May 13, 2009 2:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Parameterize Invocation ID
- Replies: 10
- Views: 9152
- Wed May 13, 2009 1:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Parameterize Invocation ID
- Replies: 10
- Views: 9152
- Wed May 13, 2009 1:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Parameterize Invocation ID
- Replies: 10
- Views: 9152
How to Parameterize Invocation ID
Hi, I have a job which loads data based on a user defined SQL into target table. Since this job is called by 2 different sequences which run in parellel, I have checked the "Allow Multiple Instance" checkbox both at job level and sequence level. When I click on the run button I need to man...
- Mon May 11, 2009 4:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Like Operator in datastage
- Replies: 4
- Views: 16905
- Mon May 11, 2009 4:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Rotine Activity triggers
- Replies: 2
- Views: 2134
Rotine Activity triggers
Hi, I have a sequence like this. JobActivity --> Routine Activity JobActivity calls a simple job. Job Output will be written to a textfile. Routine Activity calls a custom routine i.e. reads the ouput of step 1 text file. The two output possibilities of textfile is 1) it may have empty data 2) it ma...
- Mon Apr 13, 2009 3:07 am
- Forum: General
- Topic: Batch jobs
- Replies: 8
- Views: 3447
- Wed Mar 25, 2009 4:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Read COBOL file definition
- Replies: 1
- Views: 1505
Read COBOL file definition
Hi,
We have an urgent requirement that we have to read a COBOL definition file using server jobs or parallel jobs.
Is it possible to read data using CFF stage. If yes, could anybody please elaborate more on this.
Thanks..
We have an urgent requirement that we have to read a COBOL definition file using server jobs or parallel jobs.
Is it possible to read data using CFF stage. If yes, could anybody please elaborate more on this.
Thanks..
- Wed Mar 11, 2009 5:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Bad records get rejected in sequential file
- Replies: 3
- Views: 2831
Bad records get rejected in sequential file
Hi, I have some data. Following is sample data. A|B|C --> First line is column header 10|24|35 4|8|NA 98|23|NA 25|83|17 In above sample data all 3 columns are INTEGER datatype. But C column is having NA records. When I read these data through sequential file stage the bad records get rejected (i.e. ...
- Tue Mar 03, 2009 7:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: delete on db2 table
- Replies: 3
- Views: 2347
Hi, Since delete is very costly statement, one option to solve the issue is, 1. Load the required data(remaining 370 M records) to a TEMP table. 2. Truncate (or) drop the main table. Following command can be used to truncate the table. This is very fastest method. ALTER TABLE <SCHEMA.TABLENAME> ACTI...
- Mon Feb 16, 2009 3:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Migrating DS jobs from 7.5.1. to 8.1
- Replies: 3
- Views: 2554
Migrating DS jobs from 7.5.1. to 8.1
Hi, We have developed all jobs in Datastage 7.5.1(server edition) in windows server. Is it possible to migrate the jobs to Datastage 8.1 (parallel edition) in LINUX server. Since it is a different version, will there be any compatability issue. If it is there how do we take care of compatability iss...