DSXchange

Hi Ray,

My requirement is that I need to get the SQL code from a unix script.

Hi, I am trying to update a field with in the table with some where clause, when the where clause fails.....it gives me an return code of 1 which indicates failure. If we look something of this sort from Mainframe point of view, we have some thing called as Communication area where in which we get t...

Thanks for all your input it worked.

I have written a sample program #include<stdio.h> main() { print ("Hello World"); } I know that I have set up the C++ compiler bez when I type CC on the command prompt I get the help related to it. I am compiling as cc -o <Program name> It is not giving any warning during the compilation. ...

Invocation Id help's you to run the same job on the same server with the same name by multiple users at a given instance of time. If any instance of the jobs abort then the other instance WILL not be effected by this. That mean that each instance is independent of the other. Hope this clear what an ...

MyStuff,

Why don't you try a shall script for your requirement. That should help you run as many SQL as possible, as long as you have resources to attend the task.


Regards,
Sm

What is the syntax for MakeNULL(), Failed to implement this, could you please help me.

Will appreciate if you can give me an example.


Thanks & Regards,
Sm

Thanks for the Suggestion,

Though with this function, my functionality is achieved, just want to understand how I can make use of the SETNULL function in the Modify Stage.



Regards,
SM

I understand from you posting that the job will run successfully with out any warnings if given as delimited, but fails when said as Fixed width. With my exp I can only say that the fields declared as CHAR should be modified to VARCHAR. And also make user that the data is in accordance to the Metada...

With in a sample job I am trying to use the SETNULL function given by the Data Stage


Can someone help on how to use the SETNULL function?

Destination= SetNull(Source) ?


Thanks In advance.

Thanks for your inputs Firstly to answer ArndW The job is running successfully, with out any problem. My only concern is that the Data Stage Designer canvas is misleading. It shows 0 records are loaded into the output data set(file). Secondly : JoshGeorge: Is the a limitation to the tool, do we have...

When I am running a sample job where in which I have a Flat file-> Modify Stage -> Flat file With the modify stage I am dropping a column. The job is running successfully with out any warnings, but the outlink shows 0 records, the out put file has got the data in it It is only misleading in the job ...

I strongly believe that it is case of Meta data definition. Please double check the meta data, It should work fine.

Recently One of my colleague was facing the same prob.

Do let us know if you have found a solution.

HI I am using the copy stage in one of my job (to achieve the functionality) 4 times... does this by any chance reduce the performance of the job. If yes what are the other stages which can be used as an alternative to the copy stage to improve the performance. If no, does this have any other implic...

Hi, We have come across the same situation as you have been.... "Got a solution to our NEXTVAL lookup problem. It requires two DB2 enterprise edition sparse lookups with identical sql i.e. SELECT IBMREQD, NEXTVAL FOR DM01.CDM_ARR_ID AS NEXTVAL FROM sysibm.sysdummy1 WHERE (IBMREQD = ORCHESTRATE....