Search found 56 matches
- Tue Feb 08, 2011 9:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: creating a file xyz when the same file xyz is found empty
- Replies: 4
- Views: 3037
FIrst of all Let me thank you for a prompt help, to keep it simple ,my file name is xyz,it will never change, if the first file xyz is having more than or equal to 1 record,then fine else(ie if the file xyz has zero records),then I should produce a file with same above name xyz,but this time the for...
- Tue Feb 08, 2011 7:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: creating a file xyz when the same file xyz is found empty
- Replies: 4
- Views: 3037
creating a file xyz when the same file xyz is found empty
Hi One of my job's o/p is seq file xyz.csv, My req is If the o/p file xyz.csv is empty,then I should be able to generate same file xyz.csv with another field format xyz.csv field format(K1 is field name) ----------- K1 new file format xyz.csv(If the above file is empty then it should be in this form...
- Fri Nov 12, 2010 5:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to handle varchar in aggregator
- Replies: 2
- Views: 2034
- Thu Nov 11, 2010 9:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to convert 5 digit julian date to calendar date ?
- Replies: 14
- Views: 12050
Re: how to convert 5 digit julian date to calendar date ?
Hi Can you tell what is ur input and what is the out put u want
if possible quote an example
if possible quote an example
- Thu Nov 11, 2010 8:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to turn off rounding in a PX job?
- Replies: 6
- Views: 2988
Re: How to turn off rounding in a PX job?
HI Can you please explain me what do u mean by rounding the px job,
is it any particular field are yoy talking about??
Ray said using Floor function
too my knowledge it is used for a prticular field
please lemme know
thanks
is it any particular field are yoy talking about??
Ray said using Floor function
too my knowledge it is used for a prticular field
please lemme know
thanks
- Thu Nov 11, 2010 8:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Best Way to Load flat file with no delimiters
- Replies: 7
- Views: 6197
Hi, Using the left and right string functions in combination,we can reach the exact string position/extract that bit of required string and I have a question here, declare the columns appropriately in the sequential file stage and save reconverting them in a transform stage. where in seq file is pos...
- Thu Nov 11, 2010 8:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset Magic
- Replies: 10
- Views: 4832
Hi orchadmin command followed by filename 1)better to write a program in which pass the filenames as operators 2)or in the datastage ->designer->tools->dataset management->go to the path and select the dataset and delete it 3) To flush the dataset develop a job in wchi src is row generator and put t...
- Thu Nov 11, 2010 7:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Runtime Error
- Replies: 16
- Views: 8302
- Thu Nov 11, 2010 5:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Runtime Error
- Replies: 16
- Views: 8302
Hi I am assuming the datatype as varchar for the column IM_ITEM_NBR please confirm did u try executing in oracle,if u get out put then in ds also is should not be a prob please send a few records with data I guess the problem is with the kind of data the table has put the condition IM_ITEM_NBR <> 'x...
- Thu Nov 11, 2010 4:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: aggregator stage, performance is getting effect
- Replies: 5
- Views: 4770
- Thu Nov 11, 2010 4:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: aggregator stage, performance is getting effect
- Replies: 5
- Views: 4770
- Wed Nov 10, 2010 5:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to handle varchar in aggregator
- Replies: 2
- Views: 2034
how to handle varchar in aggregator
Hi All, While performing agg on key col, I would like to take few columns to next stage In that few cols,I have varchar col, SO I tried to make max or min of that varchar col and populate further I am getting a warning saying trying to convert string to decimal............... My intention is to take...
- Wed May 13, 2009 2:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_ORACLE_LOAD_OPTION
- Replies: 8
- Views: 6238
- Wed May 13, 2009 1:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_ORACLE_LOAD_OPTION
- Replies: 8
- Views: 6238
Re: APT_ORACLE_LOAD_OPTION
Hi All
the error is as follows........
PS_NW_DBALEAA_F_SF: Indexes on table 'PS_NW_DBALEAA_F_SF' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.
the error is as follows........
PS_NW_DBALEAA_F_SF: Indexes on table 'PS_NW_DBALEAA_F_SF' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.
- Wed May 13, 2009 1:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_ORACLE_LOAD_OPTION
- Replies: 8
- Views: 6238
Re: APT_ORACLE_LOAD_OPTION
PS_NW_DBALEAA_F_SF: Indexes on table 'PS_NW_DBALEAA_F_SF' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.