Search found 53125 matches

by ray.wurlod
Mon Nov 03, 2008 10:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Coversion of double to Int
Replies: 7
Views: 9758

It's not an error.

It's an alert.

Not every decimal number, not every float number can be represented as an integer.

You need to be alerted to that fact, in case you don't know what you are doing.

Include a NOWARN specification in your Modify stage.
by ray.wurlod
Mon Nov 03, 2008 10:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hardware Configuration
Replies: 4
Views: 1353

Record size is 1TB ?!!!
by ray.wurlod
Mon Nov 03, 2008 9:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generate Dates
Replies: 5
Views: 1157

Rubbish. Both the starting value and the Limit can be job parameters.
by ray.wurlod
Mon Nov 03, 2008 9:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DateFromDaysSince function
Replies: 4
Views: 2906

Try here
by ray.wurlod
Mon Nov 03, 2008 9:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: access universe
Replies: 18
Views: 7379

Have you configured the account (project) for ODBC access using HS.ADMIN menu?

Details of this are to be found in the UniVerse ODBCmanual.
by ray.wurlod
Mon Nov 03, 2008 9:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Audit script using Unix for tracking Datastage jobs
Replies: 2
Views: 1747

Ur was a city in ancient Babylon; any solutions Ur may have had perished with the city. We do not do ASAP or urgent; DSXchange is an all-volunteer site whose participants post as and when they can, if they have something to say and if they want to. If you need urgent support sign up with your suppor...
by ray.wurlod
Mon Nov 03, 2008 7:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generate Dates
Replies: 5
Views: 1157

Use a Row Generator stage.
by ray.wurlod
Mon Nov 03, 2008 7:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hardware Configuration
Replies: 4
Views: 1353

Your question is too vague. We don't know the size of a record. That said, ten million rows is not that many, so you should be able to run on the minimum configuration recommended by IBM for installing the products.
by ray.wurlod
Mon Nov 03, 2008 7:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: tables in ds repository
Replies: 1
Views: 898

Why do you need them? If you Search DSXchange you will find a complete list that I posted some years back.
by ray.wurlod
Mon Nov 03, 2008 7:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Calling a java program through datastage
Replies: 4
Views: 1448

You might also investigate the Java PACK.
by ray.wurlod
Mon Nov 03, 2008 7:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: User defined SQL in Oracle Stage
Replies: 9
Views: 2711

What problem? You assert that there is no problem in ds.
by ray.wurlod
Mon Nov 03, 2008 7:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extract substring from a string
Replies: 7
Views: 2024

What do you mean by "performance" in an ETL context? Isn't being able to perform a task better than not being able to do so?
by ray.wurlod
Mon Nov 03, 2008 7:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Clarification about rejects from a CFF
Replies: 5
Views: 2217

How about you tell us what you get on the reject link from the CFF stage?
by ray.wurlod
Mon Nov 03, 2008 7:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Clearing datastage logs from command line
Replies: 1
Views: 2070

Not really. You have no convenient mechanism from the command line to determine the name of the log table.

Also in version 8.1 you have no convenient mechanism from the command line to determine whether the log tables themselves are in a local repository or in the common repository.
by ray.wurlod
Mon Nov 03, 2008 7:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IIS-REPORTING&MONITORING
Replies: 1
Views: 860

When you upgrade to version 8.1 much of what you ask for is in the Information Server Manager.

To abort a job that is running issue a Stop request, perhaps from Director or dsjob command line interface.