hi,
I have this scenario where i will get a file and will load into table, this job runs daily, everyday when it loads it has to delete all old data,completely erase andinser only new reords. i gave "delete and insert" , that doesnt seem to work? how shall this be acheived?
Search found 28 matches
- Sat Aug 03, 2013 11:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: delete and load in odbc
- Replies: 2
- Views: 2387
- Sun Jun 02, 2013 11:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting Maximum Date using Aggregator, double to date how?
- Replies: 3
- Views: 2240
Getting Maximum Date using Aggregator, double to date how?
hi, I have to bring the latest date from a table which has tis column.I used the aggeragator groping on dummy and pulled the maximum value, now the valuse by default is in double, but i need to palce it in the datetime feild ib the target table. I am using 8.1, there is no direct decimal to date con...
- Wed May 08, 2013 8:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: last day from date
- Replies: 5
- Views: 3106
- Wed May 08, 2013 8:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: last day from date
- Replies: 5
- Views: 3106
- Wed May 08, 2013 7:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: last day from date
- Replies: 5
- Views: 3106
last day from date
i get yyyymmdd format date , i need output as yyyymmdd(but dd has to be last day of month 'mm', is there a direct funtion to pull last day of any month,
For Example: Input filed = 20130814, then output should = 20130831
For Example: Input filed = 20130814, then output should = 20130831
- Wed May 08, 2013 6:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: transformation throwing compilation error
- Replies: 1
- Views: 1406
transformation throwing compilation error
i have this requiremennt, if input field is "abc123456" then output should be "abc123456," if input is "ab123456" then output should be "ab 123456"(1 space), if input is a123456 output should be "a 123456" (2 spaces), all the time output is 9 varchar...
- Wed Apr 03, 2013 2:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job aborts giving this error
- Replies: 2
- Views: 3814
Re: Job aborts giving this error
I'm getting the exact same error. Did you ever get this resolved for yourself? I'm trying to load 100mil rows using zLoader.
- Tue Mar 19, 2013 9:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: transformation
- Replies: 15
- Views: 6027
- Tue Mar 19, 2013 9:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: transformation
- Replies: 15
- Views: 6027
- Tue Mar 19, 2013 8:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: transformation
- Replies: 15
- Views: 6027
- Tue Mar 19, 2013 8:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: transformation
- Replies: 15
- Views: 6027
transformation
Hi, if in input field, "Change Section Design" i need output as CSD , the first letter of each word in the input.how do i dot his?
- Tue Mar 12, 2013 1:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: full-outerjoin using
- Replies: 4
- Views: 2147
- Tue Mar 12, 2013 12:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: full-outerjoin using
- Replies: 4
- Views: 2147
Hi, its is notnull and varchar. To give little history wt ia m doing, i have this two bills i am comapring , Prior Vs current, In would be nending to go aand get the employeereconid added in current bill, dropped from prior bill. i ahve joined the two sqls on employee reconid and in trnasormer based...
- Tue Mar 12, 2013 12:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: full-outerjoin using
- Replies: 4
- Views: 2147
full-outerjoin using
main_program: Fatal Error: Destination "leftRec.leftRec_EmployeeReconId" is already bound.
does anybody have any idea what does this mean?
I am using this as key in full outer join
does anybody have any idea what does this mean?
I am using this as key in full outer join
- Fri Mar 01, 2013 8:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: can a field be defined Decimal(2,2) in the database?
- Replies: 2
- Views: 1676