DIRectory listing of the files
Flatten the list into a single comma delimited record of filenames
Read the file with the single record of filenames with a User Variable stage
Pass the uvParameter to the Start Loop (List Loop, Comma Delimited)
Search found 86 matches
- Wed Apr 19, 2017 12:47 pm
- Forum: General
- Topic: How to pass multiple files through looping activity
- Replies: 2
- Views: 2164
- Wed Feb 24, 2016 2:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-03127 piece-wise
- Replies: 1
- Views: 2940
ORA-03127 piece-wise
After setting up a new Development project on a separate server we started to encounter a the ORA-03127: no new operations allowed until the active operation ends fatal error. The DS Admin pointed me in the direction of the DBA, the DBA had never heard of the error and didn't have any information ab...
- Thu Mar 19, 2015 11:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Resource Disk
- Replies: 3
- Views: 1683
Thank you for the replies. Currently these are the lookup file counts by date in the Resource Disk directory 3/19 - 253 3/18 - 251 3/17 - 251 On 3/16 the DataStage server was rebooted after Windows Updates were applied. The majority of the files are very small but there are a few larger ones as well...
- Thu Mar 19, 2015 9:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Resource Disk
- Replies: 3
- Views: 1683
Resource Disk
In the Resource Disk directory there are lookuptable datasets that are several days old. I would have thought that these would get cleaned up as processes finish but apparently not or not always. Can someone advise why some of these datasets would be left in this directory for several days and what ...
- Thu Jan 15, 2015 1:48 pm
- Forum: General
- Topic: Job fails to deploy from Package
- Replies: 4
- Views: 2337
- Thu Jan 15, 2015 11:38 am
- Forum: General
- Topic: Job fails to deploy from Package
- Replies: 4
- Views: 2337
- Thu Jan 15, 2015 11:02 am
- Forum: General
- Topic: Job fails to deploy from Package
- Replies: 4
- Views: 2337
Job fails to deploy from Package
When deploying a package with multiple jobs one of the jobs fails every time. To get around this the job was moved in a dsx. The message from the compile listing is: Failed: Unexpected error importing design. See the log in the Web Console for more details. What Web Console has the log? Nothing was ...
- Thu Jan 15, 2015 7:51 am
- Forum: General
- Topic: Package of executables only failed
- Replies: 0
- Views: 1306
Package of executables only failed
After creating a package of just executables in our DEV project (all parallel jobs) the package was successfully deployed to our TEST project using ISM. To move to MODEL, which is on a different server, we are first required to send the package to the LAN where the DS Admin attempted to deploy the p...
- Fri Oct 10, 2014 6:45 am
- Forum: General
- Topic: Source changes not seen in ISM
- Replies: 0
- Views: 1196
Source changes not seen in ISM
Our shop is attempting to implement a source control system for our DataStage elements using Subversion. We have added the eclipse plug-in to ISM and can access the DS repository, Send to SC workspace, and add jobs to the SVN repository. When a job has been added to SVN the job has a suffix like 0 1...
- Thu Mar 06, 2014 4:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal fields with a space and a .
- Replies: 7
- Views: 2851
- Thu Mar 06, 2014 2:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal fields with a space and a .
- Replies: 7
- Views: 2851
- Thu Mar 06, 2014 2:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal fields with a space and a .
- Replies: 7
- Views: 2851
- Thu Mar 06, 2014 12:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal fields with a space and a .
- Replies: 7
- Views: 2851
Decimal fields with a space and a .
When writing data to decimal fields with a parallel job the value is preceded by a space and ends with a '.'.
The second field is SQL Type: Decimal, Length: 3, Scale: 0
"B", 000.,"000"
What would cause this behavior?
The second field is SQL Type: Decimal, Length: 3, Scale: 0
"B", 000.,"000"
What would cause this behavior?
- Mon Feb 10, 2014 10:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Migration to 9.1 and CRC32 function
- Replies: 9
- Views: 6131
NLS was indirectly to blame. There is a data edit routine that was modified because of NLS being enabled. One of the functions of the routine was to reduce fields consisting of only multiple spaces to a single space. This was omitted in the 9.1 version so since ' ' is not the same as ' ' the CDC cal...
- Fri Feb 07, 2014 12:37 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Migration to 9.1 and CRC32 function
- Replies: 9
- Views: 6131