DSXchange

There's no columns there called "column1", "column2", etc. Like with any other database you must use the column names defined for the table. Also, these must coincide in number, order and data type with the columns defined in your job design. SELECT DEBT_INSTRUMENT_REPAYMENT_SCHED, MINIMUM_MATURITY,...

What do you believe your alternative is?

Welcome aboard. :D You are going to need to provide rather more information than that. For example, can you connect using the other clients? What connection parameters have you specified - in particular which port number? Right now your question is in the "my car won't go - can you please help?" cla...

What have you read about the Generic stage? What do you understand that it does?

There is "an overhead" of using anything that consumes CPU cycles. Such is life in the DataStage world.

I need you to post the dictionary listing of the UV table. To get this, execute the command
Either the table name itself, or one or more of the column names (or both), just isn't working.

The file name is a property (one column returned by) the Folder stage. You can extract the date from that in the first Transformer stage, put it into another column being transmitted through the job, and use that value as a filter in the second Transformer stage. Or you could process the files one a...

The upper limit of BigInt should be 9,223,372,036,854,775,807. Where did you find that it was different? The upper limit of TinyInt (int8) is 127 (2^(8-1)-1). The upper limit of SmallInt (int16) is 32,767 (2^(16-1)-1). The upper limit of Integer (int32) is 2,147,483,647 (2^(32-1)-1). The upper limit...

Probably. A half-way decent trainer, for example. What don't you understand about what's in the manual? For that matter, which of the three different kinds of user-defined stages did you have in mind? Or do you want to create a brand-new plug-in stage that does not yet exist anywhere in the product?

Perhaps Pavan needs a new nick?

Did you mean ORD_I = '0009000311_______________________ ' ?

I would not have given it to you if it could not be used. However, I did not intend it to be used within a job at all; instead, in the generation of the job parameter LogFileName (for example) in a job sequence. "RT_LOG" : Trim(Trans("DS_JOBS",JobName,5,"X")...

What is different between dev and QA environments? Look very carefully - something is different, obviously.

Then make sure that they are all in the operating system group that is associated with objects in the project directory, and set their umask value to 002.

Why? And do "they" (who generated the requirement) require that the log continue to be preserved in a database table in the DataStage repository database? It's easy to do - you can create another DataStage job to do it. You will need to create a job sequence that gets the job number from DS_JOBS, ge...

This is as documented for the Oracle Enterprise stage. If you specify a Partition Table property it will execute in parallel provided that the table is appropriately partitioned.