Search found 25 matches
- Mon Feb 09, 2009 8:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding best option to load to oracle database
- Replies: 2
- Views: 1474
Regarding best option to load to oracle database
Hello I have a requirement like i have a huge file with 10 million records and i need to load the data to oracle table. We are using Parallel Edition on unix AIX box. Which option would be the best.I also have a requirement where if the job aborts in the middle of loading i need to rollback on what ...
- Thu Jan 24, 2008 12:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TimeStamp to Date
- Replies: 2
- Views: 1901
- Wed Jan 23, 2008 2:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TimeStamp to Date
- Replies: 2
- Views: 1901
TimeStamp to Date
My source value is like this : 2007-12-14 00:00:00 (timestamp datatype ) My desired output is : 14/12/2007 (DD/MM/YYYY)format as Date datatype Here i am extracting the data from Oracle database and loading into oracle database. I have tried several ways using To_Char and To_Date functions but in vai...
- Thu Dec 20, 2007 6:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: replacing '*' with empty string
- Replies: 3
- Views: 1708
- Thu Dec 20, 2007 11:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: replacing '*' with empty string
- Replies: 3
- Views: 1708
replacing '*' with empty string
hi i have a requirement where i am extracting the data from fixedwidth flat file and loading the data to the database after doing some transformations. the file contains some '*' values. so while loading the data to the database i need to make sure that whenever there is * in the text field i need t...
- Tue Nov 20, 2007 4:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: yesterdays date
- Replies: 2
- Views: 1379
- Tue Nov 20, 2007 3:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: yesterdays date
- Replies: 2
- Views: 1379
yesterdays date
Hi I am using currentdate-1 as parameter in the file i am producing. I am using DIGITS(DateCurrentDateTime(TimeDate())) [1,8] function to get the current date but i am wondering by using the same function is there a way i can get the yesterday's date which i want to use as a parameter in the file i ...
- Wed Nov 14, 2007 3:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error reading the fixedwidth seq file
- Replies: 4
- Views: 2401
- Wed Nov 14, 2007 2:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Modify Stage
- Replies: 5
- Views: 4339
- Wed Nov 14, 2007 2:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error reading the fixedwidth seq file
- Replies: 4
- Views: 2401
- Wed Nov 14, 2007 1:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error reading the fixedwidth seq file
- Replies: 4
- Views: 2401
error reading the fixedwidth seq file
hi i have a problem reading the fixed width seq file produced. The seq fixed width file was produced in the previous job and i can view the data but when i was trying to read the data from that file in other job Its showing the following error. ##I TFCN 000001 14:30:49(000) <main_program> Ascential ...
- Tue Nov 13, 2007 9:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: date and time in YYYYMMDDHHMISS format
- Replies: 1
- Views: 2505
date and time in YYYYMMDDHHMISS format
hi i have a job from dataset to seq file.i need to produce the file as filename.#YYYYMMDDHHMISS#.dat. i have defined one job parameter which defualts to YYYYMMDDHHMISS. i am running this job in the sequencer and i need to pass a function which gives the aboveformat to the job parameter i have define...
- Tue Nov 13, 2007 4:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: decimal datatype handling in modify stage
- Replies: 5
- Views: 3435
- Tue Nov 13, 2007 12:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: decimal datatype handling in modify stage
- Replies: 5
- Views: 3435
decimal datatype handling in modify stage
hi, i have a job from Oracle enterprsir stage to Dataset.the column QT from oracle has decimal dayatype. i am not changing the datatype of this column. In modify stage and in specification i just mentioned QT=QT and i want the output from modify to be QT with decimal datatype. the job is running suc...
- Mon Nov 12, 2007 3:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: handling nulls from dataset
- Replies: 1
- Views: 1129
handling nulls from dataset
Hi, I am extracting the data from oracle where a column QT is defined as integer.i am transferring the data from oracle stage to dataset.I am using modify stage in between. the column QT is nullable and i need to handle null values with blankspace.i tried using QT=handle_null(QT, " ") job ...