Search found 198 matches

by janhess
Thu Nov 23, 2006 3:23 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Splitting a file based on data in a different file
Replies: 1
Views: 2754

If your files are in sorted order use searchup/searchdown its much faster.
by janhess
Wed Nov 15, 2006 3:07 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Doubt in Using the Stored Procedures in the Output Card
Replies: 1
Views: 2424

If you can split your input file into a number of files you can run multiple occurrences of the map.
by janhess
Fri Nov 03, 2006 10:52 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: specific function to add months in a date
Replies: 26
Views: 19359

Can someone turn this into a function at 8.1 using the New Function fascility?
by janhess
Fri Nov 03, 2006 10:48 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Just Learning - COBOL example of real issue
Replies: 3
Views: 3781

I've fixed it.
by janhess
Tue Oct 17, 2006 2:31 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Where can I find description of Launcher Error Codes for 8.1
Replies: 2
Views: 3815

We had a problem with the IIS service crashing and restarting when requests were sent to it from 6.7.1 via Weblogic under windows 2000. This only occurred after our LDAP server crashed one night. We never found the problem and moving te system to another server resolved it.
by janhess
Tue Oct 10, 2006 9:37 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Query in Comman Line Execution for Command Server
Replies: 1
Views: 2674

What version of DSTX was the .aix map compiled under?
by janhess
Fri Oct 06, 2006 2:56 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: More a question of IBM support....
Replies: 10
Views: 8650

However, getting back to support, I have found it just as good as before in the UK. But IBM can't sort out it's licensing since the takeover. I always have to battle with them to get the correct download files for new releases.
by janhess
Fri Oct 06, 2006 2:14 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: More a question of IBM support....
Replies: 10
Views: 8650

I assume it will remain as a DataStage plugin.
Since when has DSTX just been a plugin to Datastage? It's a product in it's own right and very good for realtime transformation. I would hate to loose it.
by janhess
Fri Oct 06, 2006 2:09 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: OCI stage not available
Replies: 3
Views: 2935

Possibly if you post in the correct forum.
by janhess
Thu Oct 05, 2006 8:30 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Query about FTP Adapters- Mercator
Replies: 8
Views: 8022

try IdleFTP=10 in mercator.ini but it may be the connection is unavailable.
by janhess
Wed Sep 27, 2006 3:50 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Query about FTP Adapters- Mercator
Replies: 8
Views: 8022

The comment regarding the put function came from Ascential (now IBM) support so they should know.
by janhess
Thu Sep 14, 2006 3:20 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Execute a CMD command with -CLI option
Replies: 2
Views: 3953

You could use the batch adapter calling a batch file with a parameter eg =valid(PUT("BAT","-cmd ""ftpcmd.bat " + filename"" -P 30:10 -tv -I"," "),fail("run ftp failed " + TEXT ( LASTERRORCODE ( ) ) + " " + LASTERRORMSG())) wh...
by janhess
Thu Sep 14, 2006 3:12 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Query about FTP Adapters- Mercator
Replies: 8
Views: 8022

The PUT function with FTP adapter does not return diagnostic messages very well. It is best to run a map with the adapter. I usually run a map that has 1 input card and 1 output card both using a blob of data. The command is =run("ftpadapter",echoin(1,data to ftp ) + " -OAFTP1R3:5 '-A...
by janhess
Fri Sep 08, 2006 2:41 am
Forum: Site/Forum
Topic: WebSphere Transformation Extender
Replies: 1
Views: 2637

WebSphere Transformation Extender

Can you rename the WebSphere Datastage TX forum as WebSphere Transformation Extender as it is now known. This may stop the Datastage people posting in the wrong forum.
Thanks
by janhess
Tue Sep 05, 2006 4:15 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: How to control execution of multiple threads
Replies: 2
Views: 3570

I think this is a design issue. You should ensure that your data is in the correct order and process through a single thread.