Hi ,
If your requirement is to handle just a fixed width string "000000000000000000000000000"
then just add a simple if INPUT_VALUE="000000000000000000000000000" then 0 else INPUT_VALUE
Search found 41 matches
- Thu Dec 10, 2009 5:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to handle string"000000000000000000000000000"
- Replies: 8
- Views: 4250
- Tue Jul 21, 2009 1:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: CRITICAL ERROR!!!!
- Replies: 6
- Views: 4613
Re: CRITICAL ERROR!!!!
Hi There, I have four jobs in a sequence and when I run the sequence all the jobs with in ran successfully but the sequence failed with the error shown below. Job control process (pid 13007) has failed From previous run DataStage Job 202 Phantom 13007 Abnormal termination of DataStage. Fault type i...
- Thu Feb 12, 2009 5:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance in DS vs Oracle
- Replies: 6
- Views: 3213
Performance in DS vs Oracle
Hi, In my project the source is Oracle and target is also oracle. For some of the transformations like concatenations, substring functions are written in Oracle( in SQL) rather than doing in DS transformer. My point is that doing the smae in DS will yield good performance since DS uses parallelism c...
- Thu Nov 20, 2008 3:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: wrapDescribeOperator() error while running DS
- Replies: 0
- Views: 1505
wrapDescribeOperator() error while running DS
I am trying a run a job which was working fine all these while. Suddenly I am getting a weird error-> wrapDescribeOperator() error while running DS - fatal error .... ... ... main_program: Internal Error: (status == APT_StatusOk): sc\sc.C: 3824 Fatal..error Again if i compile and run it works fine.....
- Thu Sep 18, 2008 3:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Choosing RDBMS stage...
- Replies: 0
- Views: 1569
Choosing RDBMS stage...
My customer is interested in selecting right RDMBS environment to run DS EE to solve a multi field and relational database datamerge. The customer realiozes the value of running in parallel and which will match internal data partitioning of a given RDBMS. Which stage can be suggested...!!
- Thu Sep 18, 2008 3:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameter set what purpose does it serve?
- Replies: 2
- Views: 2659
- Mon Sep 15, 2008 4:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameter set what purpose does it serve?
- Replies: 2
- Views: 2659
Parameter set what purpose does it serve?
Hi,
I want to understand why parameter sets are used. I belive they are used to set environment variables for jobs. I read that version 8 has many modifications in parameter set!! can any one discuss abt this
I want to understand why parameter sets are used. I belive they are used to set environment variables for jobs. I read that version 8 has many modifications in parameter set!! can any one discuss abt this
- Fri Aug 29, 2008 12:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to we import SAP data into EXCEl sheet
- Replies: 3
- Views: 2852
How to we import SAP data into EXCEl sheet
How to we import SAP data into EXCEl sheet. In my job the source sap data needs to be taken into excel sheet. If i try exporting i am getting formatting errors. Eg. I have 000.20031 -> is coming as 0.20031 since we cant convert the format as text when we try to export data, i am wondering how do i p...
- Wed Aug 13, 2008 3:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: name some of the Routines to be used in PX jobs
- Replies: 5
- Views: 2839
- Wed Aug 13, 2008 3:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSSetUserStatus function use??
- Replies: 2
- Views: 2469
DSSetUserStatus function use??
Hi I want to know the use of DSSetUserStatus function. Is it talking abt the status of job like -> abort, running, success or is it something else. In my job it is used as a Transform, that means we are calling it for every record in the table. How does it reads the status of records?? SETUSERSTATUS...
- Wed Aug 13, 2008 3:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSSetUserStatus use?
- Replies: 1
- Views: 1824
DSSetUserStatus use?
Hi I want to know the use of DSSetUserStatus function. Is it talking abt the status of job like -> abort, running, success or is it something else. In my job it is used as a Transform, that means we are calling it for every record in the table. How does it reads the status of records?? SETUSERSTATUS...
- Tue Aug 12, 2008 4:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what the difference between using ODBC and oracle
- Replies: 3
- Views: 3625
what the difference between using ODBC and oracle
what the difference between using ODBC and oracle stage. What are the factors that needs to be considered to choose it?
- Mon Aug 04, 2008 4:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Phantom error -> Job aborted
- Replies: 1
- Views: 1914
Phantom error -> Job aborted
Hi..
My job is aborting because of the following reasons..
Contents of phantom output file
DataStage Job 76 Phantom 14128
writeSocket() returned 4
DataStage Phantom Finished.
Can any one say why this has happened????/
My job is aborting because of the following reasons..
Contents of phantom output file
DataStage Job 76 Phantom 14128
writeSocket() returned 4
DataStage Phantom Finished.
Can any one say why this has happened????/
- Fri Aug 01, 2008 5:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to timestamp
- Replies: 7
- Views: 7871
I have a question.. I just want to know how this function works internally.. say I have a string 20030707 StringtoTimestamp converts the given string into time. %yyyy%dd%mm says let the first four characters be year. Next two be date and next two be month isnt?? If i dont specify the format what hap...
- Fri Aug 01, 2008 4:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential File- Using multiple readers
- Replies: 4
- Views: 6493
Hi.. This is a bit tricky question.. 1 Actually a sequential file can read in ONLY ONE NODE.. Yes i do agree we have an option that says whether we can ask Datastage to keep partitions or not... This comes into picture only when we read multiple files using a sequential file. For eg. i have 3 files ...