DSXchange

Hi As i am Working in Unix i need to rely upon it for certain functions for example date etc. And later i found that there is an option in DataStage to biuld our own user defined Stages which can utilize the Unix commands(Wrapper Stage). So i need a good document of this . Can u help me? Thanks Rajesh

Search for DSParams. There parameters are stored in DSParams for particular project in Default Project directory. You can copy the file and move to the other Project folder in OS level. ... Hi Kumar_s Thanks for your reply Its realy working but i have some doubts with this, whenever we aretrying to...

chulett wrote:No such thing. You could, however, create them in one Project and then script (or manually) handle the move of the relevant DSParams data to all other Projects. ...

How we can move the relevant Parameter from one project to another.

Hi
I am working in a Parallel job where i need to create a common User defined Parameters which can be used in all the projects.
Tell me how to do this.
Thank you

chulett wrote:It is 'working fine' when the RDBMS stage is set to what - Oracle? ODBC? ...

With Oracle.

Well i can go ahead with the connection .
But am sorry i dont know what is tnsnames, Can u explain me that?

I mean that i am using this stage as Target, but i found this is working fine when i am connecting through RDBMS.

HI Month_date is the one of the column in my source which contains only the name of the month for ex"January"."March".... I need to get the last date of these months for ex "January"="2008-01-31" likewise i need to calculate the last date for all the mont in t...

Hi all, Whenever i am trying to connect an ORACLE stage in DataStage i am geting this mesasge "Local Server Missing". I can understand that it is releated to server since am not technically good in these areas i can't resolve it so please guide me how to get rid of this issue. Thank you Ra...

Hi all I have a job in which the final process is Loading. And i am loading it in a table.This is performed as a seperate job. For an example assume that there is 10,000 records in the source and its starts loading into the table without any issues upto 5000 records and after that the job has been a...

Because it's just wrong. Hope Ray doesn't mind this... 4. In simple Server Edition is Code oriented sort of job where as Parallel edition is user friendly. That is complete tosh. Most good server jobs can be created without writing a single line of code. Expressions need to be built in both variant...

chulett wrote:

mcs@rajesh wrote:4. In simple Server Edition is Code oriented sort of job where as Parallel edition is user friendly.

I'm sorry, but this one just made me laugh. As Ray notes, complete 'to ...

Hi chulett I'am sorry, but can I know what made you to laugh so much if you tell us whole DSXchange can laugh.

Hi Rake, well i don't have any document regarding this but i can suggest you some important differences, they are 1.Server Edition does'nt have Concept called Partition and collection 2.It executes the job which is present in the same server(machine). 3.It works fine with small volume of data. 4. In...

Hi Rave, well i don't have any document regarding this but i can suggest you some important differences, they are 1.Server Edition does'nt have Concept called Partition and collection 2.It executes the job which is present in the same server(machine). 3.It works fine with small volume of data. 4. In...

The basic idea behind the configuration file is to allocate the nodes to the Parallel job which makes it to run parallely and it will allocate the memory space according to the job ...
bye..