Search found 53125 matches

by ray.wurlod
Mon Jul 30, 2007 4:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: what does this c++ code do??
Replies: 7
Views: 2974

Before we do that, do you understand C/C++ syntax at all? And have you read the chapter on programming within parallel jobs?
Please post the pre-loop code (where, for example, the variable called holdkey is initialized).
Please ask more specific questions.
by ray.wurlod
Mon Jul 30, 2007 3:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Records Drop Due to NULL
Replies: 14
Views: 2310

Time to mark the thread as Resolved, then.
by ray.wurlod
Mon Jul 30, 2007 3:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with DB2/UDB Load Stage
Replies: 5
Views: 2257

Click on the Help for each of these properties (the Property Help button). The first is the pathname where you want the DAT and CTL files to be created. There is a suitable default if you leave it empty. The second is the pathname of the file that will receive any messages generated by the bulk load...
by ray.wurlod
Mon Jul 30, 2007 3:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To read the rejected record in error table created by TPUMP
Replies: 1
Views: 828

Looks like an incompatibility between using signed and unsigned integer. This is a bug. Report it via your support provider.
by ray.wurlod
Mon Jul 30, 2007 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Routine Sql to list all jobs linked to specific table-fails
Replies: 15
Views: 6588

My error. The table name needs to be single-quoted. cmd = \SELECT EVAL DS_JOBOBJECTS."IF INDEX(@RECORD,'\ : vTableName : \',1) > 0 THEN 'FOUND' ELSE 'NTFND'",\ cmd := \ DS_JOBS.NAME AS JOB_NAME FMT '40L' \ cmd := \ FROM DS_JOBS,DS_JOBOBJECTS \ cmd := \ WHERE DS_JOBS.JOBNO = DS_JOBO...
by ray.wurlod
Mon Jul 30, 2007 3:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error viewing data using ODBC for Informix.
Replies: 5
Views: 4306

"Transaction not available" is an alert message indicating that your Informix database is a NOLOGGING database - because there is no transaction logging then you can't do transactions. However, this should not prevent a SELECT from occurring. There is, I believe, an environment variable that can sup...
by ray.wurlod
Mon Jul 30, 2007 3:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Pick up new files only
Replies: 6
Views: 1399

Note that it's the STATUS statement not the STATUS() function.
by ray.wurlod
Mon Jul 30, 2007 3:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: strange login error
Replies: 3
Views: 996

Check in your /etc/hosts file whether the name "ServerA" contains the IP address of ServerB.
by ray.wurlod
Mon Jul 30, 2007 3:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Target Load strategy
Replies: 12
Views: 5160

Something like

Code: Select all

IsNull(InLink.TheTimestamp) Or (InLink.TheTimestamp = "")
by ray.wurlod
Mon Jul 30, 2007 3:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML Importer errors
Replies: 4
Views: 1611

Could be that there's a design limit on the size of an XSD file (256K?). I don't know whether this is the case - just my guess - but the vendor will be able to provide a definitive answer through your support provider.
by ray.wurlod
Mon Jul 30, 2007 3:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Managing sequential unique keys
Replies: 11
Views: 3671

What Craig said. The column whose value will be generated by calling the sequence does not appear in (the final part of) the job design at all. INSERT INTO table (c1,c2,c3,c4) VALUES myseq.NEXTVAL,:1,:2,:3 For this example only columns c2, c3 and c4 would occur on the input link of the stage...
by ray.wurlod
Mon Jul 30, 2007 3:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: spreadsheet and table comparison
Replies: 6
Views: 1397

I would think it needs to be
UPDATE table SET a = :1, b = :2, c = :3, d = :4, e = :5 WHERE a = :1

Make sure there are only five columns in your metadata.
by ray.wurlod
Mon Jul 30, 2007 3:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Deploy DataStage over Microsoft Cluster
Replies: 4
Views: 1114

Can you be more precise about what is meant by "deploy"? In server edition DataStage server can only be on one machine; processing will not be distributed to other machines. But, in general, files and databases on other machines can be accessed. No use will be made of the cluster architecture by Dat...
by ray.wurlod
Mon Jul 30, 2007 3:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage 5.2.1 in Windows 2003
Replies: 2
Views: 1491

It's not a supported combination. I am not aware of anyone who is running that particular combination. But other unsupported combinations work, so you may be lucky. Let us know, since you're going to do it anyway. Make sure you have a good backup and a good export of each project (one taken with not...
by ray.wurlod
Mon Jul 30, 2007 3:22 pm
Forum: General
Topic: IBM information server-Installtion failure
Replies: 4
Views: 1253

Get your support provider to earn some of their maintenance money.