Search found 53125 matches

by ray.wurlod
Thu Jun 25, 2009 4:11 pm
Forum: IBM QualityStage
Topic: Cleaning a particular pattern/text : DataStage
Replies: 8
Views: 3725

Or a simple If..Then..Else expression in a Transformer stage.
by ray.wurlod
Wed Jun 24, 2009 11:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need help on parallel routines
Replies: 7
Views: 2015

Don't you mean "some" body? Because "some" body is more likely to be able to resolve "some" error.

"Some error" is impossible to diagnose. Supply the actual error text and you are more likely to receive cogent responses.
by ray.wurlod
Wed Jun 24, 2009 5:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Comparing Jobs
Replies: 6
Views: 1791

From the client menu, it's "Cross Project compare".
by ray.wurlod
Wed Jun 24, 2009 4:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merging Version of Jobs
Replies: 8
Views: 2863

WHY do they want this?

<rant>Resist stupid requirements!</rant>
by ray.wurlod
Wed Jun 24, 2009 1:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Send Mail for warning Rows
Replies: 25
Views: 6025

It doesn't work? In what way? There should be a way to do this with an External Filter stage - you probably need to be more canny with the script that the stage invokes.

Or, perhaps, an External Target stage terminating that particular link.
by ray.wurlod
Wed Jun 24, 2009 1:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to get into Designer & Director
Replies: 6
Views: 2233

It may be listening on port #2300 (because the MKS Toolkit telnetd listens on port #23). Try

Code: Select all

telnet servername 2300
by ray.wurlod
Wed Jun 24, 2009 1:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compilation Error in Routine
Replies: 2
Views: 1115

And you need to name the correct constant, in this case DSJ.ERRWARN.
by ray.wurlod
Wed Jun 24, 2009 1:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to log in IBM Datastage after reboot of server
Replies: 30
Views: 20714

As you observe, we have proven that the local DataStage server has recorded the projects correctly. If you wanted to test that any particular one of these was operable you could use DataStage/SQL for that too. For example CD D:\IBM\InformationServer\Server\Projects\LibProject PATH=%PATH%;D:\IBM\Info...
by ray.wurlod
Tue Jun 23, 2009 11:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What ports does DataStage really use?
Replies: 12
Views: 9120

Umm.. CLASSPATH ?

I have a vague feeling that there's also an APT... environment variable, but maybe that's just for the JRE.
by ray.wurlod
Tue Jun 23, 2009 11:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: rather than ftp ,is they any method to collect my files
Replies: 7
Views: 1775

Use any utility (ftp, rcp, ODBC bridge for example) to move the flat files from the AS/400 to your DataStage server. Once there, they can be processed with DataStage. If the data are encoded using EBCDIC there are functions in the SDK for effecting conversion of particular data types. The move can b...
by ray.wurlod
Tue Jun 23, 2009 11:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to log in IBM Datastage after reboot of server
Replies: 30
Views: 20714

We're making some progress. You have proven that UV_SCHEMA and UV.ACCOUNT are not corrupted. These are the only two tables that are involved in checking for existence of accounts. The next thing to do, again from DSEngine, is to query each table. Execute the following commands (redirect output to ca...
by ray.wurlod
Tue Jun 23, 2009 8:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to log in IBM Datastage after reboot of server
Replies: 30
Views: 20714

Y was never the right answer. Now you have three unnecessary hashed files and their dictionaries in the bin folder. CD to the bin folder (make VERY SURE that you are there and not in DSEngine) and get rid of VOC, VOCLIB, &SAVEDLISTS&, D_VOC, D_VOCLIB and D_&SAVEDLISTS&. Please convi...
by ray.wurlod
Tue Jun 23, 2009 5:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: patch to connect to sqlserver2005
Replies: 9
Views: 2764

chulett wrote:Define "not working" please.
Another word for "not working" is unemployed
by ray.wurlod
Tue Jun 23, 2009 4:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Administrator getting hanged
Replies: 9
Views: 1964

Please verify which port number has been opened.
by ray.wurlod
Tue Jun 23, 2009 4:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to get into Designer & Director
Replies: 6
Views: 2233

Control Panel > System > Environment