Search found 23 matches

by somesh2suma
Sun Jan 24, 2010 10:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: want to compare size & count of 2 files through unix scr
Replies: 3
Views: 1813

hey sreedhar,

Thank you very much,
Actually the below expr without END worked perfectly--

File_size=`ls -la | grep $filename | awk '{ print $5 }'`

It reduced lot of my time. Thanks again.
by somesh2suma
Fri Jan 22, 2010 1:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: want to compare size & count of 2 files through unix scr
Replies: 3
Views: 1813

want to compare size & count of 2 files through unix scr

hi i am writing a script to compare file size of two files and also row count of 2 files, one is called as src1.data in Arrival directory with src1.OK file in Source directory. And if its not equal then it should exit with status fail. Please let me know the logic and unix code for this functionalit...
by somesh2suma
Fri Jan 22, 2010 1:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to delete temporary datasets after jobs get completed
Replies: 3
Views: 2411

hi

Even i have the same problem, but i want to put it in job control.
"../bin/orchadmin rm nameofthedataset"
canl this above command placed in job control or should we have to place in unix script.

Thanks in advance.
by somesh2suma
Tue Dec 29, 2009 3:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: want to create parallel routine from server routine
Replies: 3
Views: 1306

hey thanx for the reply...

can you please tell me where is this available and how to make use of this if its available...

i tried checking the transformer options, but its not available there.
by somesh2suma
Mon Dec 28, 2009 11:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: want to create parallel routine from server routine
Replies: 3
Views: 1306

want to create parallel routine from server routine

hi somebody please help me to write the equivalent parallel routine for the below server routine: Ans=Arg1 Call DSSetUserStatus(Ans) Call DSLogInfo("user status set to":Ans,"Set User Status Call") where Arg1=if IsNull(Column_name) Then "NotScheduled" Else Column_name i ...
by somesh2suma
Mon Dec 28, 2009 6:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need help on parallel routines
Replies: 7
Views: 2462

what will be the full path for include statement....

mdbatra,

Hey please let me know what is the full path for include statement... even i am facing the same problem.
by somesh2suma
Thu Apr 09, 2009 9:07 am
Forum: General
Topic: want to know maximum value a decimal can store or propagate
Replies: 0
Views: 611

want to know maximum value a decimal can store or propagate

Hi All i want to know the maximum value or digits that a decimal datatype can store and propagate to the next stage. For example: if decimal(20,0) is declared and assigned with 999999999999999999 value it will give a negative value after moving to the next stage. So would like to know if any rule to...