Search found 107 matches
- Mon Aug 13, 2012 11:59 am
- Forum: General
- Topic: Change delfault path for importing jobs/unlock a folder
- Replies: 5
- Views: 2370
- Mon Aug 13, 2012 8:48 am
- Forum: General
- Topic: Change delfault path for importing jobs/unlock a folder
- Replies: 5
- Views: 2370
Change delfault path for importing jobs/unlock a folder
We are trying to import some jobs (from .dsx files) and the jobs are trying to import to a specific folder that seems to have been accidentally locked by us. My questions are: 1. How to change the folder to which the jobs get imported ?(we are importing the jobs using the 'Import' option in the Data...
- Fri Aug 03, 2012 10:10 am
- Forum: General
- Topic: Job starts,gets completed but does no processing
- Replies: 4
- Views: 2165
- Fri Aug 03, 2012 10:04 am
- Forum: General
- Topic: Job starts,gets completed but does no processing
- Replies: 4
- Views: 2165
The summary log is posted and please let me know if a detailed log is needed too. Thanks. Occurred: 4:31:17 PM On date: 8/2/2012 Type: Info Event: xfm_IntlFreXtract,10: Numeric string expected . Use default value. (...) Occurred: 4:31:17 PM On date: 8/2/2012 Type: Fatal Event: main_program: ORCHESTR...
- Fri Aug 03, 2012 7:41 am
- Forum: General
- Topic: Job starts,gets completed but does no processing
- Replies: 4
- Views: 2165
Job starts,gets completed but does no processing
Hello,
We have a sequence of jobs and one of the jobs in the sequence starts and gets completed successfully but does not do any processing. It is like the job starts and completes and skips all the stages in the middle.
Any suggestions on why this might be happening is greatly appreciated.
Thanks.
We have a sequence of jobs and one of the jobs in the sequence starts and gets completed successfully but does not do any processing. It is like the job starts and completes and skips all the stages in the middle.
Any suggestions on why this might be happening is greatly appreciated.
Thanks.
- Mon Jul 30, 2012 9:31 am
- Forum: General
- Topic: Invocation IDs and output file name
- Replies: 3
- Views: 1966
- Mon Jul 30, 2012 8:57 am
- Forum: General
- Topic: Invocation IDs and output file name
- Replies: 3
- Views: 1966
Invocation IDs and output file name
Hello, We need to run a sequence of jobs and each job in the sequence has to be run for different parameters. The sequence need not be run in parallel and can be run one after the other for different parameters. We would like to append the parameter to the output file name after each job in the sequ...
- Wed Jul 11, 2012 3:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help on rounding a decimal to nearest integer multiple
- Replies: 14
- Views: 4886
Thanks Craig and Ankur. I have implemented the following and performing some testing. if(Mod(Decimal,Integer) >= Integer/2) then AsInteger((Decimal/Integer)+1)*Integer else AsInteger(Decimal/Integer)*Integer The problem occurs when my Integer rounding value (which was assumed to be 5 earlier) turns ...
- Wed Jul 11, 2012 1:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help on rounding a decimal to nearest integer multiple
- Replies: 14
- Views: 4886
- Wed Jul 11, 2012 12:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help on rounding a decimal to nearest integer multiple
- Replies: 14
- Views: 4886
Need help on rounding a decimal to nearest integer multiple
Hello, I need help on rounding a decimal value to the nearest multiple of the given integer. For example, if the value is 2747.334566 and the given integer is 5, the value must be rounded to 2745. If the value is 2748.23456 and the given integer is 5, the value must be rounded to 2750. Any help is g...
- Wed May 09, 2012 9:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Identify records that generate warnings/errors
- Replies: 3
- Views: 3098
- Tue May 08, 2012 2:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Identify records that generate warnings/errors
- Replies: 3
- Views: 3098
Identify records that generate warnings/errors
Hello, What is the best method of identifying records that generate warnings/errors? We have millions of records as input and we implement the StringToDate() function and some records generate the following warning in the log: Conversion error calling conversion routine date_from_string data may hav...
- Fri May 04, 2012 2:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transpose/pivot logic needed
- Replies: 8
- Views: 4505
- Fri May 04, 2012 7:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transpose/pivot logic needed
- Replies: 8
- Views: 4505
- Thu May 03, 2012 9:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transpose/pivot logic needed
- Replies: 8
- Views: 4505
Thanks Ray. I had one more questions. According to the requirements, the number of rows can be between 1 and 4. For example: Column1 Column2 Column3 Column4 Column5 Row1 a b c c1 1000 Row2 a b c c2 2000 Row3 a b c c3 3000 Row4 a b c c4 4000 Row5 d e f c1 5000 Row6 d e f c3 6000 Row7 d e f c4 7000 Th...