DSXchange

Hi,

What is a better solution when we have say 4 modules each expected to have say 50-75 jobs, should we have 4 seperate projects, one for each, or one project with all 4 as categories..what would be the pros and cons.

Thanks in advance,
NV

Hi All, Thanks for all the replies. Just to clarify,yes we would like to delete all the jobs as well when we would want to delete the category conatining it. The reason for this is, when we move a category (all jobs) to Production, we would like to clean up that category in DEV so as to ensure the n...

Hi,

Is it possible to delete a category and not the full project from the command line..may be from a Unix script.

Regards,
NV

Hil, We have installed the Java Pack Plug in and are able to see the Java Client & Java Transformer stage in the palette under Real Time.When I try to drag this stage on the Parallel Canvas, it throws the message " (40906) Unable to create new object". (Need for this is that we want to...

Has anyone worked on the External Source stage?
I need to read a file from a URL path and pick the last record only. Any solution for this?

Regards,
Nirav

Hi thompsonp,

Thanks for ur prompt response.The advanced guide does list all the header file names.
Where on the DS server (path) can I find these Header files to be able to have a look at them, if I can!

Regards,
Nirav

Hi, I need to come up with a couple of Build stages for certain complex functionality in PX. Is there any help on the language & functions that can be used for building this stage? e.g APT_DATE::daysInYear(<year>) Also what is the basic difference between Custom, Build & Wrapper stages? Rega...

Hi,

Datastage PX:
Can we use the Development/Debug stages like the peek, tail , head in Dev only or we can use them during the UAT & Production environment too.
If No, why can we not use it?

Yes, the DirectConnect or DataDirect (can't recall what they are called these days) drivers will let you read the .xls file directly using ODBC and the drivers are platform specific, so the driver on LINUX won't work on SOLARIS. Best ask the pricing and portability questions to the vendor directly....

Hi All,

Will the DataDirect driver for Linux help me in reading an Excel file directly with Datasatge installation on Linux? Any idea about the Cost involved?
Also going forward we could move to a Sun Solaris box..so in that case do we need to buy another driver or should this work fine there too

NV

How about the Java Client plug in stage? It is availabe in the Server edition and can do what I am looking for. Is is available in Datastage PX?

My source file is coming from Windows Env and is in Excel format.
Can I read from it through DS on a Unix Env without having to manually convert it to a .csv file?
Pls reply ASAP.

Hi,

How can we get the Operator_id (value) saved to a column
? is there any routine/macro/function available for it?

NV