Search found 53125 matches

by ray.wurlod
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

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.
by ray.wurlod
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

For every VarChar, Char, Decimal, Float and Double column, check to see that there is a non-zero entry in the Precision cell in the Columns grid.
by ray.wurlod
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...
by ray.wurlod
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

In that case can you please illustrate what you ARE getting? That might give us some clues.
by ray.wurlod
Thu May 21, 2015 11:37 pm
Forum:
Topic: Shouldn't the dev catalog have query building capabilities?
Replies: 10
Views: 10629

Then I guess it's "the one after that", which doesn't officially have a version number yet. I have seen this very issue discussed in Business Partner briefings; I'm not making it up!
by ray.wurlod
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
by ray.wurlod
Thu May 21, 2015 5:05 pm
Forum:
Topic: Shouldn't the dev catalog have query building capabilities?
Replies: 10
Views: 10629

Well, I've been here for a while! Check my post count. :wink:
by ray.wurlod
Thu May 21, 2015 5:00 pm
Forum: General
Topic: Installing Datastage 8.7 on Hadoop Cluster
Replies: 5
Views: 3886

This functionality will be available in the next version (the one after 11.3.1). The engine executes directly on the Hadoop cluster, with "grid management" handled through YARN. This technology is currently in beta testing, and seems to be standing up well. I think that putting $DSHOME on ...
by ray.wurlod
Thu May 21, 2015 4:58 pm
Forum: General
Topic: dssh remote connectivity
Replies: 2
Views: 1326

Provided that both DEV and TEST environments are managed by the same application server, you should be able simply to specify the command line arguments for the DEV environment in your istool command. The "remote" part will be handled via the metadata access service.
by ray.wurlod
Thu May 21, 2015 4:55 pm
Forum: General
Topic: How to configure ODBC DSN for Teradata database
Replies: 2
Views: 1723

Use the ODBC Administrator from the SYSWOW64 folder.

Make sure that you do not create a User DSN, since DataStage will not recognize it.
by ray.wurlod
Thu May 21, 2015 4:54 pm
Forum: General
Topic: Unable to see the menu bar in datastage designer
Replies: 3
Views: 1924

Since you can't see the menu (therefore no View option) you may have to go into the Windows Registry to re-enable display of the menu. Search DSXchange to find the technique.
by ray.wurlod
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
by ray.wurlod
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

Where (in which stage) is this expression with Ereplace() functions being used, and what value do you expect that it is returning?
by ray.wurlod
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

So all you're missing is the enclosing Redemption tags?

How are you generating the XML (e.g. with what stage, and with what Xpath expressions)?
by ray.wurlod
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

Check the value of the Record Delimiter property. If this is UNIX style, change it to use the Record Delimiter String property set to DOS style.