Search found 124 matches

by Roopanwita
Wed May 21, 2008 4:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORACLE error ,Unable to find log file
Replies: 3
Views: 1130

ORACLE error ,Unable to find log file

Hi, while loading from a sequential file to a ORACLE table ,I am getting error "ora_tgt,3: The system(sqlldr CONTROL=<**>ctl LOG=<**>log BAD=ora<**>log.bad SILENT=header PARFILE=ora<**>par) failed; see the log file for the Oracle specific message.". I have gone through the post and found t...
by Roopanwita
Mon May 19, 2008 7:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle error
Replies: 4
Views: 1007

Is the above problem is because of too long target table name / job name?
by Roopanwita
Mon May 19, 2008 7:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle error
Replies: 4
Views: 1007

Oracle error

In one job while loading from Sequential file to Oracle table (in Oracle table Load Option is Create ) job is throwing error ORA-00972: identifier is too long . I shaeched from google ,but couldn't get meaning of identifier is too long

Can anyone please help me out?

Thanks,
Roopanwita
by Roopanwita
Fri May 16, 2008 3:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex Flat File +Filler
Replies: 7
Views: 1763

Filler column is used to add space to make line length 1000 or 2000 byte.
In file (while loading from CCF to ORACLE stage) there is one more default column DELTA CHARACTER(1) . and value of that column is 'X'
Can you please tell me what is the use of that column?
by Roopanwita
Fri May 16, 2008 3:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex Flat File +Filler
Replies: 7
Views: 1763

Actully my question is ,do filler column in table has physical existance in table?
by Roopanwita
Fri May 16, 2008 1:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex Flat File +Filler
Replies: 7
Views: 1763

Complex Flat File +Filler

Hi, In one job we r loading from complex flat file to Oracle stage.CFF stage is of 1000byte,so I am using a Filler Column.There is also one more column "Delta" ..same colum is getting populated in target. Do these columns are actual column.? do they have physical existance in table? or Whi...
by Roopanwita
Fri May 16, 2008 1:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex Flat File
Replies: 2
Views: 739

Complex Flat File

Hi,
Can any one tell me what is the What is level_number in COBOL file?

Thanks,
by Roopanwita
Thu Apr 24, 2008 6:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error SIGABRT
Replies: 2
Views: 1211

This is basically a UNIX signal sent to terminate process.From this error masg can we find the reason of unwanted termination of process?Can this be result of segmentation fault?
by Roopanwita
Thu Apr 24, 2008 3:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error SIGABRT
Replies: 2
Views: 1211

Error SIGABRT

Hi,
I am testing a sequence in DS 8.0,in job log ,status is showing Finished but in Log detail there is a fatal error,xml_etl_err,0: Operator terminated abnormally: received signal SIGABRT.Can anyone plase tell me what is meant by SIGABRT.
Thanks
Roopanwita
by Roopanwita
Thu Apr 17, 2008 9:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Comparison of DataStage 7.5 and 8.0
Replies: 4
Views: 2497

Thanks for your reply. It is tru that tester is more concerned about output.But my question is, with change in version there is a change in functions ,format of functions .Eg ,ver 8 got more advanced features & function. Like change in functions/function format ,what are other things that need t...
by Roopanwita
Thu Apr 17, 2008 5:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Comparison of DataStage 7.5 and 8.0
Replies: 4
Views: 2497

Comparison of DataStage 7.5 and 8.0

I am working in a DS project in which exiting codes will be moving from DS 7.5 to DS8.0. So which factors should be considerded/tested while testing to run code properly in new version.
Thanks
by Roopanwita
Mon Apr 07, 2008 5:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to set up alert mechanisms based on the DS logs
Replies: 8
Views: 3717

Sorry for miscommunication.
Actully i wanted to capture part of msg Log ,i'e no of records procrssed..
if there is any fatal error in job,then from Log want to capture error msg line.
Thanks