Search found 103 matches

Go to advanced search

by sagar deshmukh
Fri Jan 16, 2009 7:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle stage...
Replies: 1
Views: 1008

Oracle stage...

Code: Select all

i am loading data into oracle tables and suppose the jobs gets aborted at 101st record...so does it means that it has insertred 100 records into the table..
and if so,....and if we dont want the job should commit any records if it gets aborted then what we need to do..
[/quote]
by sagar deshmukh
Fri Jan 16, 2009 7:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: abort a job
Replies: 4
Views: 1856

u can use a job control to read the records in the link once it goes beyond the perticular level u can abort it,
by sagar deshmukh
Fri Jan 16, 2009 7:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading the parameter
Replies: 3
Views: 1693

Reading the parameter

I have seen a sequencer...where we are passing the parameters through shell script....to the sequencer....i mean shell script will rerad the parameters from a parameter file and will be given to the job.... In sequencer again we have a Routine stage....where the routine will read the parameters and ...
by sagar deshmukh
Fri Jan 16, 2009 7:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: can we write routines in PX?
Replies: 6
Views: 1723

So aftter writting routine in C++ we need to copy it into the same DS compiler...
Also....Is there any need atall to routines......
by sagar deshmukh
Fri Jan 09, 2009 2:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: can we write routines in PX?
Replies: 6
Views: 1723

i mean can we use DS basic routines in PX or we need to write them in C++
not sure so wish to know.....

if yes...

Same routine which is used in server can be used in PX?
by sagar deshmukh
Fri Jan 09, 2009 12:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: can we write routines in PX?
Replies: 6
Views: 1723

can we write routines in PX?

can we use routines in PX?
by sagar deshmukh
Fri Jan 09, 2009 11:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date formating help needed
Replies: 6
Views: 1842

Well, i got it...Some bracket missmatch happned...
evry time we have to use both Iconve and Oconv?
by sagar deshmukh
Fri Jan 09, 2009 11:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date formating help needed
Replies: 6
Views: 1842

i did not get you, Can you please give the example of the format, am getting compilation error
by sagar deshmukh
Fri Jan 09, 2009 10:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date formating help needed
Replies: 6
Views: 1842

Date formating help needed

How to convert mm/dd/yyyy to yyyy-mm-dd in transformer stage.I dont want to use substring
by sagar deshmukh
Tue Jan 06, 2009 6:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading .csv file.
Replies: 2
Views: 1336

Reading .csv file.

I am FTPing .csv file from remote server and then concatiating it to a "R.csv" file, but when i am trying to read that "R.csv" file by using sequential stage data stage is reading just 1st row and its giving warning as "nls_read_delimited" row -1, too many column in a ...
by sagar deshmukh
Fri Jan 02, 2009 3:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help needed for FTP stage...
Replies: 27
Views: 11754

I am realy really sorry Sir....Hats off to u....
finally it worked.....
i missed.."DSAttachJob" part....
sorry...i been working since more than 24 hrs so......brain not working...
thanks alot,.,,,,
by sagar deshmukh
Fri Jan 02, 2009 3:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help needed for FTP stage...
Replies: 27
Views: 11754

DEFFUN RunRestartableJob(JobName,HASHPATH,BatchNumber,SKIPPARAM) Calling "DSU.RunRestartableJob" DEFFUN EmailErrorMessage(HASHPATH,BatchNumber) Calling "DSU.EmailErrorMessage" DEFFUN JobControlReset(JobList) Calling "DSU.JobControlReset" DEFFUN RunBatch(JobList, Params...
by sagar deshmukh
Fri Jan 02, 2009 2:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help needed for FTP stage...
Replies: 27
Views: 11754

Code: Select all

Batch::CopyOfLNRemitMaster..JobControl (fatal error from DSGetJobInfo): Job control fatal error (-1)
(DSGetJobInfo) Invalid job handle 2
after using your code i got above error
by sagar deshmukh
Fri Jan 02, 2009 1:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help needed for FTP stage...
Replies: 27
Views: 11754

JobName = "hashProcessControlDTS" BatchName = DSGetJobInfo(DSJ.ME, DSJ.JOBNAME) Errcode = RunRestartableJob(JobName,HASHPATH,BATCHNUMBER,"BATCHTIMESTAMP=":BatchStartDts) If Errcode Then GOTO ENDJOB End JobName = "srcDlyCalcTxns_LN" BatchName = DSGetJobInfo(DSJ.ME, DSJ....
by sagar deshmukh
Fri Jan 02, 2009 12:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help needed for FTP stage...
Replies: 27
Views: 11754

JobName = "srcDlyCalcTxns_LN" BatchName = DSGetJobInfo(DSJ.ME, DSJ.JOBNAME) result = DSGetLinkInfo(DSJ.JOBNAME,DSJ.ME,DSJ.ME,DSJ.LINKROWCOUNT) Errcode = RunRestartableJob(JobName,HASHPATH,BATCHNUMBER,"BATCHTIMESTAMP=":BatchStartDts) If Errcode Then GOTO ENDJOB End If result > 0 ...

Go to advanced search