Search found 195 matches

by deesh
Thu Feb 09, 2012 11:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting non-proper sequence result by surrogate stage
Replies: 6
Views: 2002

Hi ray,

No other job using the same state file and if i run the on sigle node it is providing the correct result why not on 4 node configuration.......
by deesh
Thu Feb 09, 2012 3:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting Fattal while doing XML input stage operation
Replies: 5
Views: 3305

Hi,

I am using below sequence:

Sequence file ---> XML Input ----->Sequence file.

While trying with External source stage It's giving error.

External_Source_6,3: Operator terminated abnormally: runLocally() did not return APT_StatusOk
by deesh
Thu Feb 09, 2012 3:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting non-proper sequence result by surrogate stage
Replies: 6
Views: 2002

Getting non-proper sequence result by surrogate stage

Hi, I am implementing a surrogate key stage in my job, but the stage is not giving proper sequence and i have given below properties block size - 1 next highest value - yes but still giving un sequence number the result is coming like EMPNO,ENAME,SKEY 1,JA,45 2,GA,64 3,KL,92 4,JK,94 Please can any o...
by deesh
Thu Feb 09, 2012 1:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting Fattal while doing XML input stage operation
Replies: 5
Views: 3305

it is surprising, once again i tested the XML job, job was not accepting more than 3 records. If i enter 4th record, below warning was getting... EMPNO,ENAME,JOB,SAL,DEPTNO these are fields i have given. XML_Input_0,0: Info: test_on_xml_in.XML_Input_0: Xalan fatal error (publicId: , systemId: , line...
by deesh
Wed Feb 08, 2012 2:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting Fattal while doing XML input stage operation
Replies: 5
Views: 3305

Getting Fattal while doing XML input stage operation

Can any one please help in below Fatal error: APT_CombinedOperatorController,0: Fatal Error: Fatal: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 28, column: 3): Invalid character (Unicode: 0x0) APT_CombinedOperatorController,0: Fatal Error: Fatal: XML i...
by deesh
Wed Nov 23, 2011 10:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: main_program: warning
Replies: 2
Views: 1525

main_program: warning

Hi,
Can any one explain the below warning message and in which situation below warning generally occured, tell me the solution for the below warning.

"main_program: When validating export schema: At field "j": Exporting nullable field without null handling properties"
by deesh
Wed Nov 23, 2011 10:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential_File_1,0: Import warning at record 0:
Replies: 10
Views: 6902

sorry, I mean the sequential file stage doesn't showing the property, while extracting(Input).
by deesh
Wed Nov 23, 2011 6:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential_File_1,0: Import warning at record 0:
Replies: 10
Views: 6902

Hi,

There is no "First line column Headings" while in sequential file, this sequential file extracting the data with.txt format and sending data to .csv format.

in ouput file, i have given "First line column Headings" =TRUE, but in input sequential property i didn't find.
by deesh
Tue Nov 22, 2011 11:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential_File_1,0: Import warning at record 0:
Replies: 10
Views: 6902

there is no option or property like "First Line is Column Headings" in sequential file INPUT.

is there any alternative than above property.
by deesh
Sat Nov 12, 2011 1:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential_File_1,0: Import warning at record 0:
Replies: 10
Views: 6902

Sequential_File_1,0: Import warning at record 0:

Hi I have importing the data from sequential file, I am getting the correct reult but below messages are showing as warnings. can any one help to me in which we get this kind of warnings and solution for that. Sequential_File_1,0: Field "j" has import error and no default value; data: {j},...
by deesh
Mon Jun 20, 2011 5:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal error.
Replies: 3
Views: 2032

Hi,
Following message getting.

main_program: The section leader on ITEM-43826 died.


main_program: Unable to contact one or more Section Leaders.
Probable configuration problem; contact Orchestrate system administrator.
by deesh
Thu Jun 16, 2011 3:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal error.
Replies: 3
Views: 2032

Fatal error.

Hi, After installation i ran my job, it was showing below message, please can any one suggest, how i should solve the below issue. main_program: **** Parallel startup failed **** This is usually due to a configuration error, such as not having the Orchestrate install directory properly mounted on al...
by deesh
Thu Jun 16, 2011 12:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hi Required a solvation for the rule.
Replies: 1
Views: 1185

Hi Required a solvation for the rule.

Hi,

I have data like:
xx,yy
1,z
1,y
2,x
2,w
My required output looks like:
xx,zz
1,z|y
2,x|w

can any help me out how to solve the above rule
by deesh
Tue Jun 14, 2011 11:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: want to pass unique and dup record seperately
Replies: 3
Views: 2182

Re: want to pass unique and dup record seperately

Hi All, Problem was solved. see the below process. source file---> select option in Sort stage (Create Key change column (True)), it produce unique records in "1", dup records in "0",----> Filter stage take two output links one for dup, second for unique records filter based on c...