Search found 53125 matches

by ray.wurlod
Fri Oct 01, 2010 4:14 pm
Forum: IBM QualityStage
Topic: upgrade QualityStage from 7.01 to 8
Replies: 4
Views: 2123

That said, if your maintenance agreement (and payments) are up to date, you are ENTITLED to a free upgrade. Be aware, though, that the hardware requirements are significantly higher in version 8 than in version 7 - QualityStage is no longer a separate product but one of a suite of products called In...
by ray.wurlod
Fri Oct 01, 2010 6:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage MQ connectivity
Replies: 3
Views: 6236

That the JobMonApp is running tells you nothing about the Node Agent.

Try netstat -a | grep 31531
by ray.wurlod
Thu Sep 30, 2010 7:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Function to check for strings
Replies: 2
Views: 1266

Umm... I think your terminology lacks a little something. Do you mean "check for non-numeric characters" or "check for alphabetic characters" or some such? The Num() function will check whether it's purely numeric, or you could use IsValid() to check whether it's an integer. Anot...
by ray.wurlod
Thu Sep 30, 2010 7:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Transformer in Parallel Jobs
Replies: 4
Views: 1566

It WILL run on multiple nodes. The main reason for its relative slowness is the need to convert to and from the typeless DataStage BASIC environment to the strongly-typed C++ environment of parallel jobs for every row processed.
by ray.wurlod
Thu Sep 30, 2010 7:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to check valid date ?
Replies: 7
Views: 3890

You can find it here.
by ray.wurlod
Thu Sep 30, 2010 4:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Maximum length of a varchar field
Replies: 5
Views: 5976

Because text files don't have data types (other than "text") VarChar(255) is used as a default. DataStage has a really high limit on length of a VarChar (64K ?); however some databases limit it (for example to 1024) making you use Long VarChar for anything larger.
by ray.wurlod
Thu Sep 30, 2010 4:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extract data from Lotus Notes using ODBC
Replies: 5
Views: 1694

No, that's just a generic error. Were there any other warnings in the log?
by ray.wurlod
Thu Sep 30, 2010 4:04 pm
Forum: General
Topic: java based application?
Replies: 1
Views: 1165

No. DataStage has some Java components, has some ActiveX components, has some VB components, has some C++ components, and that's just in the client! The server engine is pretty much all written in C and DataStage BASIC. The parallel engine is primarily written in C++.
by ray.wurlod
Thu Sep 30, 2010 1:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pivot Stage
Replies: 9
Views: 3883

You need YEAR, JAN_NAME, FEB_NAME, MAR_NAME, JANUARY, FEBRUARY, MARCH

Populate JAN_NAME, FEB_NAME and MAR_NAME with constants and pivot them.
by ray.wurlod
Wed Sep 29, 2010 11:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extract data from Lotus Notes using ODBC
Replies: 5
Views: 1694

You should be OK with that combination.

Try this trick if you're permitted to do so. Set up a Lotus Notes user with an empty password, then use that for access.
by ray.wurlod
Wed Sep 29, 2010 11:38 pm
Forum: General
Topic: Datastage Credentials
Replies: 5
Views: 3923

Where did you "check" the Web Console? DataStage credentials are in the Domain Management menu. They won't be enabled if you're not: (a) an Information Server Administrator (b) a DataStage and QualityStage Administrator (c) a DataStage and QualityStage User They may also not be enabled if ...
by ray.wurlod
Wed Sep 29, 2010 11:36 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Varchar to bigint conversion
Replies: 3
Views: 2113

So why did you post the question in the Information Analyzer forum?
:?
by ray.wurlod
Wed Sep 29, 2010 7:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Creating OSH Script
Replies: 8
Views: 6359

When the job is compiled, the generated OSH script should be visible in the Job Properties workspace. It also gets written into the job log. However this is never the script that gets executed. When the job is run, a new script, called the "score", is written. The score takes into account ...
by ray.wurlod
Wed Sep 29, 2010 5:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TNS could not resolve error!!
Replies: 10
Views: 6435

Look in your job log. An early event in a job run (typically the second entry) lists the environment variable values that were used.
by ray.wurlod
Wed Sep 29, 2010 5:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel Lookup questions
Replies: 1
Views: 1225

Error code 11 is an access violation. Parallel jobs load the entire reference data set into memory (if it's a Lookup stage reference input). If you don't have enough memory - if the executing user can not allocate enough memory - it will throw an access violation.