Search found 53125 matches

by ray.wurlod
Thu Jun 08, 2006 3:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Setting Job parameter at runtime from lookup stage
Replies: 5
Views: 1570

Why not just select max(field) + 1 from the table?
by ray.wurlod
Thu Jun 08, 2006 3:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: implicit conversion error
Replies: 6
Views: 4797

Re: implicit conversion error

Hi, I am getting this error while i am using oracle as a lookup. Oracle_Enterprise_10: When checking operator: When binding output interface field "MRATE" to field "MRATE": Implicit conversion from source type "dfloat" to result type "sfloat": Possible range/precision limitation. Can anybody help T...
by ray.wurlod
Thu Jun 08, 2006 3:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: web service to call sequence job
Replies: 5
Views: 1153

Old design stage1 ----> stage2 ----> stage3 or some variant thereof. New design RTI_Input ----> stage1 ----> stage2 ----> stage3 ----> RTI_Output or, more likely (if the web service is to deal with XML documents) RTI_Input ----> XML_Input ----> stage1 ----> stage2 ----> stage3 ----> XML_Output ---->...
by ray.wurlod
Thu Jun 08, 2006 3:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performamce tuning
Replies: 5
Views: 1412

Not yet. It's new. There are only three papers in there.
by ray.wurlod
Thu Jun 08, 2006 3:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Routine Error
Replies: 2
Views: 1422

Is this a new job sequence design, or one that has suddenly begun to demonstrate this behaviour? If it's a new design, try deleting the Routine activity and replacing it with a new one.
by ray.wurlod
Thu Jun 08, 2006 3:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: OS/390 ODBC connection setup problems
Replies: 10
Views: 3902

Is a "/" permitted in the Location field? (I don't know the answer to this, but the rest of the definition (except, maybe, Collection and for the same reason) looks OK. Does what's in the ODBC data source definition match what's possible in your DB2 client configuration?
by ray.wurlod
Thu Jun 08, 2006 2:54 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Cross Table Analysis across multiple databases
Replies: 2
Views: 3165

I can't see why not. All data access is via ODBC, so all you should have to do is to define multiple DSNs.
by ray.wurlod
Thu Jun 08, 2006 1:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: web service to call sequence job
Replies: 5
Views: 1153

Check the job properties. Is there an RTI Service Enabled check box? That is your answer. For those who don't have RTI, the answer is that RTI is available for server and parallel jobs, but not for job sequences. The reason is that, if you publish a DataStage job as a web service, it must have some ...
by ray.wurlod
Thu Jun 08, 2006 1:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in using DS Routine
Replies: 17
Views: 4225

If you find that the job name checks out OK, check the stage name. "Trasnformer_1" seems to me to be misspelled.
by ray.wurlod
Thu Jun 08, 2006 1:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job May be Being Monitored
Replies: 2
Views: 4868

The most likely cause of this message is that you or someone else has opened a Monitor in Director on this job. You or someone may then have minimized the monitor and forgotten that it was open.
by ray.wurlod
Thu Jun 08, 2006 1:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to assign value to Environment Variable from a table
Replies: 3
Views: 1152

You can, but you don't want to, because the UNIX based ODBC drivers that you will need to license cost megabucks. If you would like to research this strategy search the forum for "BCI". A better approach is a job sequence that runs a job to extract the values from the table into either a text file o...
by ray.wurlod
Thu Jun 08, 2006 1:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Change License number
Replies: 5
Views: 1904

(a) yes (b) yes The entire licensing model is not discussed anywhere. You might like to search the forum for DS_LICENSE (the name of a hashed file in which connected client information is stored). There is, of course, more to it than that; for example licensing control is actually done in shared mem...
by ray.wurlod
Thu Jun 08, 2006 12:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What exactly is a PHANTOM ERROR or a PHANTOM STATE?
Replies: 1
Views: 749

"Phantom" is DataStage terminology for "background process", which a simple search of the forum would have revealed to you.
by ray.wurlod
Wed Jun 07, 2006 11:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job May be Being Monitored
Replies: 2
Views: 1420

The most likely cause of this message is that you or someone else has opened a Monitor in Director on this job. You or someone may then have minimized the monitor and forgotten that it was open.
by ray.wurlod
Wed Jun 07, 2006 11:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running batch file from a routine
Replies: 6
Views: 1132

I wonder whether some re-wiring of file units is happening?

Try

Code: Select all

ftp -s:%0.txt > %0.log 2>&1

Also try

Code: Select all

start -b -w "ftp -s:%0.txt > %0.log"
so that it gets another environment in which to work.

Just some ideas. No guarantees.