DSXchange

Can you post your schema?

I mean for the input stage.

Hi Everybody , I am working on datastage from the past 3 months.We are working on DATASTAGE 8.0.1 version on LINUX box. I am facing some problem in NULL handling .My scenario is as below I am having a sequential file . its a COMMA DELIMITED. 12,99,jkl,10082008,a 12,,mno,,a 13,20,klo,11062008,b So i...

ray.wurlod wrote:Convert it to decimal. E3 becomes 227.

You mean like with a Modify stage beforehand?

Can anyone tell me how I would represent a hex constant in the where predicate of a filter stage?

var_x = 'E3'xb is the equivalent Teradata expression. And I get the feeling osh will throw up on this.

Thanks.

Oops. I forgot to include the link.

http://sourceforge.net/projects/pydatastage

Hello all. I just created and posted a new open source project on SourceForge called PyDataStage. This is a Python extension using the DataStage job API that allows you control jobs and retrieve log information for jobs using Python. It is a work in progress and so far I have only tested this on AIX...

We are using MQ with HAWK both with real-time components, the Oracle UOW operator and a customer MQ UOW operator at this installation. Although we do have local queues, the work is done on queues local to the mainframe. To repeat a question from earlier - can you execute the command "dspmq&quo...

The thread has strayed from its original topic. DataStage does NOT generate an executable file. DataStage parallel jobs generate an osh script. When the job is run, a new osh script (called the "score") is written, taking into account the currently selected configuration. The score is exe...

All DataStage wants to know about are the MQ queue manager and teh MQ queue name. If those can be accessed from the DataStage server command line using the mq commands (i.e. "dspmqaut") then you are good to go from DataStage. Is anyone here currently using Hawk with MQ Series? If so, how ...

It can connect to queues on other servers. The local queue manager uses MQ intercommunication to communicate with the remote queue manager(s). And is this intercommunication something that must be configured in DataStage, MQ or both? What exactly is the nature of this MQ intercommunication? Does it...

So if DataStage is installed on the same server as MQ server, can it connect to queues on another server? Or can DataStage only connect to local queues?

I learned Torrent Orchestrate first on my own then took DataStage classes from Ascential when the product was assimilated into DataStage.

Oh yeah. I don't know if this holds for other databases, but for DB2 if the input and lookup tables are in the same database, it's most efficient to do a join in the DB2 read (in this case an outer join), since DB2 does a better job optimizing retrieval of data from its database than DataStage does....

I have been able to successfully use the MultiFieldAccessor class to iterate over all fields in a record with out referring to them by name. I can get the name and type of each field and can access their values. This will come in handy for performing mass scrub operations on fields with various type...

Hi Gurus, i have to perform a lookup on a table(lookup with 4 columns).... the reference stream has data of around 6million rows.. what i was thinking was to use merge stage(as i wanted to handle the rejects as well) instead of lookup stage(which would reduce the performance)... i think i can also ...