Search found 86 matches

by hhh
Thu Sep 21, 2006 1:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to overwrite seqfile through basic command.
Replies: 3
Views: 1295

How to overwrite seqfile through basic command.

Hello, While using following command in our routine OpenSeq PathName To FileVar Else ; * Open the sequential file or if not exist then create seq file CREATE FileVar ELSE ABORT ,If file already exists and we want to overwrite our data so we can not able to overwrite the i/p data on particular file w...
by hhh
Thu Sep 21, 2006 1:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: No proper output while running routine
Replies: 4
Views: 1551

Have updated my code with code tags and comments.


[quote="kduke"]Please edit your post and put code tags around your program so we can see the indentation.[/quote]
by hhh
Wed Sep 20, 2006 9:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: No proper output while running routine
Replies: 4
Views: 1551

No proper output while running routine

While running following routine $INCLUDE DSINCLUDE JOBCONTROL.H InfoMessage = Arg1 PathName = Arg2 Output ='' OpenSeq PathName To FileVar Else ; * Open the sequential file or if not exist then create seq file CREATE FileVar ELSE ABORT WriteSeq InfoMessage TO FileVar ELSE STOP ; * writing input argum...
by hhh
Mon Sep 18, 2006 8:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning sh: dbx: not found/Xml Tfm stage
Replies: 5
Views: 4186

I dont have other message except "main_program: Unexpected exit status 1 Unexpected exit status 1", and i am testing with 2 rows only currently

[quote="kumar_s"]Do you get any other messaage related to Section Leader or node player?
What is the volume of the data?[/quote]
by hhh
Mon Sep 18, 2006 6:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning sh: dbx: not found/Xml Tfm stage
Replies: 5
Views: 4186

Warning sh: dbx: not found/Xml Tfm stage

In Xml Transformer stage i am geting warning message "XML_Transformer_6,0: sh: dbx: not found" and error message "XML_Transformer_6,0: Operator terminated abnormally: received signal SIGSEGV" Have set the environment variable APT_DISABLE_COMBINATION as true, but it doesn't impact...
by hhh
Mon Sep 18, 2006 4:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read Xml File
Replies: 1
Views: 1247

Read Xml File

I have xml file and i want to pass this xml file to another format through output xml stage,
how can i read data from xml file(Source file) so i can make new format through output Xml stage.

can anyone help me for same

Thanks,
Hiten
by hhh
Sat Sep 16, 2006 12:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem while ruuning the routine
Replies: 1
Views: 1047

Problem while ruuning the routine

While running routine with two input arguments, i am getting runtime message TEST #1 ******* Arg1 = sequential_file_123 Arg2 = /auto/abc.txt Test completed. Result = Program "TSTMatchFieldTest.B": Line 4, Variable "ANS" previously undefined. Empty string used. ********** $INCLUDE...
by hhh
Fri Sep 15, 2006 7:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with DSExecute command
Replies: 3
Views: 1960

Thanks Mark!!!

[quote="OttMAdpttch"]Hiten,

You need to set a variable to the Unix command you wish to execute and then use this variable in the DSExecute funtion.

Cmd = 'grep ':Filename:' ':Pathname
Call DSExecute('UNIX',Cmd,Output,SystemReturnCode)[/quote]
by hhh
Fri Sep 15, 2006 6:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with DSExecute command
Replies: 3
Views: 1960

Problem with DSExecute command

While using this command in routine : Call DSExecute("UNIX",grep 'File' PathName,Output,SystemReturnCode)
I am getting following warning msg : 'WARNING: Variable 'grep' never assigned a value'
could you please provide your inputs on this warning
regards,
Hiten
by hhh
Thu Sep 14, 2006 1:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass arguments to Unix script
Replies: 6
Views: 2896

In every job design , we have put the same suffix string for ex. files names in first job are abc_SF, def_SF ,ghi_LKP ,jkl_LKP and second job these may aaa_SF,bbb_SF,ccc_SF,ddd_LKP,eee_LKP . I think we cann't use with DSGetLinkInfo(), because we dont have same naming convention except suffix string ...
by hhh
Wed Sep 13, 2006 7:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting Warning message(Phantom Msg)
Replies: 2
Views: 1201

Thanks, after changing DSJ.JobStatus to upper case letter DSJ.JOBSTATUS i am not getting any warning [quote="ray.wurlod"]Check out the mnemonics for error codes (DSJE...) in JOBCONTROL.H. Also in this file you will observe that the mnemonics for function arguments must be all upper case, s...
by hhh
Wed Sep 13, 2006 4:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting Warning message(Phantom Msg)
Replies: 2
Views: 1201

Getting Warning message(Phantom Msg)

Hi, I am passing JobName to following routine $INCLUDE DSINCLUDE JOBCONTROL.H Equate RoutineName To 'JobRunStatusHitRef' If JobName[1,1] = '\' Then ; *jobname starting with '\' is a category not a job Ans = 'This is not a job' End Else If JobName = DSGetJobInfo(DSJ.ME,DSJ.JOBNAME) Then ; * Checking ...
by hhh
Wed Sep 13, 2006 2:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass arguments to Unix script
Replies: 6
Views: 2896

I want to use server routine and after getting some job information from each job then want to pass info message to unix for searching the string so i can find Number of i/p records Number of O/p records, rejected records Can you be more precise about what you want to do? It appears that you want to...
by hhh
Tue Sep 12, 2006 4:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass arguments to Unix script
Replies: 6
Views: 2896

Pass arguments to Unix script

I have JobName and JobNo fields whch i want to pass into unix script as arguments.There are number of records for those two fields.

How can i pass JobName and JobNo to unix script ?
Pls suggest your ideas for same.
by hhh
Fri Sep 08, 2006 7:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: creating job statistics from joblog created in datastage
Replies: 11
Views: 6947

Our requirement has been changed and need to generate routine in parallel job, stll i have not created parallel routine,this is different than server routine, can you pls give me idea how to implement the routine in px ?