Search found 53125 matches

by ray.wurlod
Thu Jul 05, 2012 4:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Write an XML file with multiple elements in the same node
Replies: 7
Views: 7516

Server job (as marked) or parallel job (as posted)?
by ray.wurlod
Thu Jul 05, 2012 4:18 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Can we analyze the data from a flat file
Replies: 5
Views: 2635

Go through the "Identify Flat File" process of metadata import, which will create metadata from your flat file into the file QETXT.INI used by Information Analyzer. (You can create the entries in QETXT.INI manually, but it's a tedious and painstaking process. Far better to let the computer...
by ray.wurlod
Wed Jul 04, 2012 4:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal values getting expanded
Replies: 8
Views: 3255

Floating point numbers can not be stored accurately in computers; this relates to the fixed size of the binary mantissa and exponent. Review the relevant IEEE standards to understand more. Meanwhile, try using Decimal rather than Float as the data type.
by ray.wurlod
Wed Jul 04, 2012 4:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Read excel file (.xls) in to datastage
Replies: 4
Views: 10987

The ODBC driver for Excel has very stringent requirements. The worksheet must be in strict columnar format with column headings.
by ray.wurlod
Wed Jul 04, 2012 4:21 pm
Forum: General
Topic: Console for IBM Information Server not working properly
Replies: 3
Views: 740

Welcome aboard. I have never seen this problem.

You may need to run the AppServerAdmin script to designate (or re-designate) your WAS administrator who will de-facto become an Information Server administrator.
by ray.wurlod
Wed Jul 04, 2012 5:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading data from datasets to text file
Replies: 3
Views: 1718

Ultimately using a DataStage job or orchadmin execute the same functionality.
by ray.wurlod
Wed Jul 04, 2012 5:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rollbacking transactions
Replies: 1
Views: 1006

Independent Connectors are independent of each other. Depending on the commit interval/rows, and the array size, records will be committed to the target database(s) as those threshholds are attained. If the stage aborts, then any uncommitted records should be rolled back. In each Connector independe...
by ray.wurlod
Wed Jul 04, 2012 5:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to call oracle stored procedure in datastage server job
Replies: 8
Views: 7612

The empty parentheses signify that the list of arguments is zero long.
by ray.wurlod
Wed Jul 04, 2012 5:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Questions about Configuration File
Replies: 5
Views: 1553

1) The first is a node pool list, the second is a disk pool list. 2) The first disk pool list is empty, the second disk pool list is not empty. 3) This is a list containing four node pool names (the first is "", which is the default node pool). The other three names have no particular mean...
by ray.wurlod
Wed Jul 04, 2012 5:01 am
Forum: General
Topic: User connection issue with 8.7
Replies: 14
Views: 5681

Did you even read what we wrote?
by ray.wurlod
Tue Jul 03, 2012 4:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to call oracle stored procedure in datastage server job
Replies: 8
Views: 7612

I'd expect a different error message in that case.
by ray.wurlod
Tue Jul 03, 2012 4:30 pm
Forum: General
Topic: 8.7 Installation with Firewall Up
Replies: 3
Views: 1211

The installation script reminds you to stop the firewall. That should tell you something. You might try installing with the firewall running, but you must first identify every possible port number that Information Server or any of its components may use, and on which tier(s), and open those ports. O...
by ray.wurlod
Tue Jul 03, 2012 4:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameterising write mode
Replies: 2
Views: 1218

As a general rule properties that can take their value from a drop-down list cannot be parameterised.
by ray.wurlod
Tue Jul 03, 2012 4:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to call oracle stored procedure in datastage server job
Replies: 8
Views: 7612

Perhaps you need to qualify the SP name with its schema name, so that it is unambiguously indentified.
by ray.wurlod
Tue Jul 03, 2012 4:23 pm
Forum: General
Topic: User connection issue with 8.7
Replies: 14
Views: 5681

To summarise: Suite component role DataStage and QualityStage Administrator or DataStage and QualityStage User must be granted before any user can access DataStage. Those users with DataStage and QualityStage Administrator role automatically are registered as administrator role in each DataStage and...