Search found 88 matches

by chandra
Sun Mar 08, 2009 9:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSGetLinkInfo,dsjobrun,APT_DUMP_SCORE
Replies: 4
Views: 5232

DSGetLinkInfo,dsjobrun,APT_DUMP_SCORE

How to execute this comands DSGetProjectList,DSGetLinkInfo,dsjobrun,APT_DUMP_SCORE.
please gice one brefie example .

Thanks in Adv
by chandra
Tue Aug 21, 2007 10:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sybase timestamp convertion problem
Replies: 2
Views: 1726

sybase timestamp convertion problem

hi !
from source-sybase i am getting 859 recordes , I hv one field which generates timestamp 2006-01-20 00:00:00 i want to convert into 2000120 format. Itried to convert but in tranformer is droping some records .
No errors and warrings are comming !
by chandra
Mon Aug 20, 2007 4:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing record as parameter
Replies: 2
Views: 2151

Passing record as parameter

Hi frnds -

I want to pass the start and end date as parameter.
Data are stored in text file.
Please guide is that possible in DS
by chandra
Mon Aug 20, 2007 4:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Left outer join
Replies: 5
Views: 2680

Left outer join

how to find which one is left dataset / right dataset in join.

A--

--join-- assume iam doing leftouter join, how find which one left Ds
b--
by chandra
Sun Aug 19, 2007 10:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Audit file should match Source file
Replies: 3
Views: 2275

its a kick of job, not related to loading ..

job :-

match-->kick rest of job
else
Abort send a mail to team
by chandra
Sun Aug 19, 2007 9:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Audit file should match Source file
Replies: 3
Views: 2275

Audit file should match Source file

Hi Frnds @ i hv one problem and looking for logic. i get source file which contains actual data and another file is Aduit file. where i get summary of source file. like how many number of records and amount. ex:- record count, amout->200,2500000.00 --------------------------- Source file should matc...
by chandra
Thu Aug 16, 2007 11:39 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Compare 2 datasets- probelm
Replies: 1
Views: 3951

Compare 2 datasets- probelm

I want to compare the out put of the 2 datasets if they mismatch i want to abort the seq. this is the error i got when i was trying to compare Error:- main_program: Fatal Error: Attempt to drop schema variable: "first.rec"; this may be due to dropping a subrec which contains a schema varia...
by chandra
Wed Aug 15, 2007 9:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DECIMAl 19,4 to deciaml 12,2 prob
Replies: 3
Views: 2401

when i aggregate Source the value is coming as NULL in target.
by chandra
Wed Aug 15, 2007 8:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DECIMAl 19,4 to deciaml 12,2 prob
Replies: 3
Views: 2401

DECIMAl 19,4 to deciaml 12,2 prob

I want to convert decimal(19,4) to decimal(12,2)
by chandra
Tue Dec 05, 2006 9:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to handle restarting of subsequnces in Failure cases
Replies: 18
Views: 7691

If your using tivoli as a scheduler then u can start any sequence.
I dnt think there is checkpoint concept present in 7.0,6.0 in llrle and server version.
by chandra
Mon Dec 04, 2006 1:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date conversion
Replies: 8
Views: 4369

Thanks !!!
by chandra
Mon Dec 04, 2006 1:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UNION ALL v/s FUNNEL Design Issue
Replies: 6
Views: 13030

I am out of touch with datastage ! can you please tell me what is this :-
sequential funnel, if your requirement is that, other wise go for continous funnel .

I know only funnel stage ! i never went into properties of it .
by chandra
Mon Dec 04, 2006 12:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: HOW TO COMPARE DATES IN SQL SERVER QUERY
Replies: 3
Views: 2850

Correct me if im wrong !

date it self is string .
by chandra
Mon Dec 04, 2006 12:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: C++ routine Vs Aggregator stage
Replies: 9
Views: 5084

is there any group by key ! in you count .
by chandra
Mon Dec 04, 2006 12:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with loading Timestamp filed into Oracle
Replies: 15
Views: 7373

Check you MM and DD formats ! may be it got swaped by mistake .