Search found 4 matches
- Tue Mar 06, 2018 10:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert hexadecimal string to decimal
- Replies: 2
- Views: 3995
Convert hexadecimal string to decimal
We are looking for a solution to convert a hexadecimal string to a decimal within Datastage. The source system provides an 8 character string. Input: 01FEE741 Output: 33.4825610 Input: FAD4F96B Output: -86.7058160 We have used SQL Server functions to convert the string but would like to eliminate th...
- Thu Jan 11, 2018 6:15 pm
- Forum: General
- Topic: Select rows from table and use results as parameter to job
- Replies: 6
- Views: 5211
- Fri Jan 05, 2018 6:58 pm
- Forum: General
- Topic: Select rows from table and use results as parameter to job
- Replies: 6
- Views: 5211
Thank you for your response. I did manage to create a job sequence that called a parallel job to output the list of employees to a sequential file. The job sequence then read the file content and looped through both the file list and a date range calling the parallel job that then executes a web ser...
- Tue Jan 02, 2018 10:45 am
- Forum: General
- Topic: Select rows from table and use results as parameter to job
- Replies: 6
- Views: 5211
Select rows from table and use results as parameter to job
I have created a parallel job that retrieves a list of employee numbers from a table. The resulting rows are passed to a transformer stage. The TSF stage generates additional rows for each employee based on a date range. The TSF also adds information needed to call a web service to each row. The out...