You're getting the idea and, when you get your premium membership, you'll also get the technique for accomplishing it.
Premium membership is the mechanism by which the hosting and bandwidth costs of DSXchange are funded. We prefer that mechanism to allowing advertisements on the site.
Search found 53125 matches
- Fri May 22, 2015 3:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Add total record count and total reject count in log file.
- Replies: 4
- Views: 1425
- Fri May 22, 2015 3:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: [IBM][CLI Driver] CLI0143E Invalid precision value
- Replies: 7
- Views: 6146
- Fri May 22, 2015 3:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Add total record count and total reject count in log file.
- Replies: 4
- Views: 1425
Write the new lines, and any required empty lines, to a dummy file. Then use TYPE command to append the log file. Then delete the log file, and rename the dummy file. The first of these steps is probably done with a fourth DataStage job, the others can be done in an after-job subroutine invoked from...
- Thu May 21, 2015 11:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to load attributes in xml tag using xmlstage
- Replies: 10
- Views: 3005
- Thu May 21, 2015 11:37 pm
- Forum:
- Topic: Shouldn't the dev catalog have query building capabilities?
- Replies: 10
- Views: 10629
- Thu May 21, 2015 5:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Separately Group Rows then Re-group them in Exact Order
- Replies: 9
- Views: 1950
Code: Select all
svProject <-- If InLink.Col1 = "Type 1" Then InLink.Project Else svProject- Thu May 21, 2015 5:05 pm
- Forum:
- Topic: Shouldn't the dev catalog have query building capabilities?
- Replies: 10
- Views: 10629
- Thu May 21, 2015 5:00 pm
- Forum: General
- Topic: Installing Datastage 8.7 on Hadoop Cluster
- Replies: 5
- Views: 3886
- Thu May 21, 2015 4:58 pm
- Forum: General
- Topic: dssh remote connectivity
- Replies: 2
- Views: 1326
- Thu May 21, 2015 4:55 pm
- Forum: General
- Topic: How to configure ODBC DSN for Teradata database
- Replies: 2
- Views: 1723
- Thu May 21, 2015 4:54 pm
- Forum: General
- Topic: Unable to see the menu bar in datastage designer
- Replies: 3
- Views: 1924
- Thu May 21, 2015 4:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Separately Group Rows then Re-group them in Exact Order
- Replies: 9
- Views: 1950
I don't think there's any need for a loop. Create the stage variable as, say, type Integer with an initial value of 0. Then, each time the value "Type 1" occurs, increment it.
Code: Select all
svGroupNumber <-- If InLink.Col1 = "Type 1" Then svGroupNumber + 1 Else svGroupNumber- Thu May 21, 2015 4:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup failing for partial matched records
- Replies: 5
- Views: 2450
- Thu May 21, 2015 4:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to load attributes in xml tag using xmlstage
- Replies: 10
- Views: 3005
- Thu May 21, 2015 4:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex flatfile warning
- Replies: 5
- Views: 2672