DSXchange

Hi Everyone,

I am trying to call sqlplus from a script and executing query.

I want sqlplus to return only the data and no headers (column names) footers (number of rows returned). How can I suppress these?

Hi everyone,

Can you tell me, which stage do we need to use to connect to SQL server.

And is it possible that SQL Server 2005 will be installed on Unix or can it be only installed on windows.

Thanks

Hi, If we used the following code in routine EARLIER Statements .... Call DSU.ExecSH(UnixCmd, ErrCode) If ErrCode <> 0 Then Call DSLogFatal("failed.", rtnName) ....... NEXT Statements Will the ErrCode check wait for the unix command to be completely executed i.e for example if i have issue...

I was looking at the Database plugins in datastage and Saw that Informix plugin has CLI written on it? is it command line interface? Why is that different from other database plugins?

Hi Sud,

Would be great if you could provide the link.

Regards

Can I get some info about orchestrate operators.

We havent got parallel extender installed yet over here.

But I would like to get knowledge before hand on it. Is there a possibility of getting documnets on

a) Tutorial parallel jobs
b) orchestrate operators

thank you

Hi, If i have two job activities in a sequence. first one being parallel job and second one being server job. If the output of first job is input to second job. Do we need to convert the .ds (dataset for eg.) to sequential file and then pass on to server or will server job be able to read the .ds fi...

Hi, I need to extract data from Oracle1 and have to update Oracle2 Without any transformation, direct one to one mapping. Does it matter if I have i) Oracle -> Flat File -> Transformer -> Oracle ii)Oracle -> Transformer -> Oracle Is there any necessity with regards to performance to have flat file i...

what is the difference between DSU and without DSU?

Thought for any datastage provided routines we need to use DSU.

Its working right now

Thanks

I used the following code $INCLUDE DSINCLUDE JOBCONTROL.H dump=Arg1 Ans=0 UnixCmd="cat /nz/etl/dev/wrk/pwd_mms_etlext" Call DSU.DSExecute("UNIX",UnixCmd,SystemOutput,ErrCode) Ans=SystemOutput But it gives the following errors Program "DSU.TryUnix": Line 8, Unable to ope...

Hi Everyone, In routines, i am using UnixCmd="cat ""\PATH":"Filename" Call DSU.ExecSH(UnixCmd,Error) I need to have the value read from the file in order to return it from routine. So taht I can use it in my jobs. How can I get the result of the executed command Thanks ...

Hi All,


I created a batch to run the sequences in order, i.e one after the other. But I want to CERTAIN sequences to run in parallel. How can i do that.


Thank You

Hi there, I am stuck with a SQL query. Not able to figure out how to go with it. I have got 3 tables. a) Core_Client Fields : client_nbr, brn_nbr b) Other_Client Fields client_nbr, brn_nbr, sub_nbr c) Oper_geo Fields sur_geo_id,brn_nbr, sub_nbr Join Relationship : Table A is left joined to Table B b...

Hi Everyone, I am new to write Basic programs. In the manager I saw where we can compile and Test the basic code (although would like to have better interface to debug step by step, able to see variables etc) The Ascential document speaks about a) CREATE.FILE, type 1 or type 19 b) RAID command for d...