DSXchange

Hi Muju,

Did you got any soluction how to build and use c routine in DS

lstsaur wrote:Tell us what does your own stage try to accomplish.

it has to read schema file and do the lookup dynamically and out put the data dynamically.

i have writen .dll in wchich stage we can all the dll and how to send the parameters for that...

Thanks
Shivadas

Select the Stage Types branch of your Repository. Using the New tool/menu, create a new parallel stage type. Do your coding in the GUI exposed after you choose your stage type (build, custom or wrap ... i want to build my own stage... can tell me which is the best opton ........ generic/custom stag...

Hi,

how do i build user define stage.
where do i do a coding for that stage
how do i call them.

Thanks
Shiva

ray.wurlod wrote:Make them wherever you like, using a text editor. Call them using osh. ...

Hi ray,

Can you tell me how are they used the DS Px. i dont understand how exactly use them. these files have to be compiled...?
where can i get more help on these ...

Thanks
shiva

Hi Ray/All,

Can you tell me the use of opd and osh files.
how do i make them (code new opd/osh files)
use them
and where do call them.(in custom stage/generic/etc)

Thanks
Shiva

Hi,

I wanted to use some of .h file to perform a task.
How do i call the .h files and send the values to to functions in that class. Is it like c++ stype, create a class and invoke with class.function name with required parameters if yes where do i create a coding for this?

Thanks
shivadas

Hi Ray, This is my default.apt file contains { node "node1" { virtmem 512 physmem 128 fastname "SHIVA" pools "node1" "node1s" resource disk "d:/Datasets" { pools ""} resource scratchdisk "d:/Scratch" { pools ""} } } This...

Hi All, I am facing the following problem when i a m trying to run PX job. Any one have a soluction for this error? ##I TFCN 000001 16:15:01(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved ##I TOSH 0...

Hi, Even i am getting the same error while executing the parallel job, Can you let me know what is the soluction. error log: ##I TFCN 000001 16:15:01(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved #...

with Command stage where do i give Login details
Batch job using DSExecute API call to sqlplus command line ALWAYS works. Can you please help me with syntax


Shiva

sachin1 wrote:hello you can use Stored_Procedure stage with no input or output. in output by default you will have ProcCode, ProcMess columns.

in syntax tab you mention your procedure name and take procedure_type tab value as Transform.

i am using 7.1 Datastage stored_procedure stage is in 7.5

thanks
shiva

Hi,

can any one help me?

I am wanted to call a oracle store procedure which dont accept any arguments or return any values.

How do i execute this procedure?
ODBC stage expect out parmeters from the store procedure, but this procedure doesnot return any thing.


Needed urgently please

Shiva

Hi, I have some records in this manner, A,AT1,GT1 A,AT1,GT2 A,AT2,GT1 A,AT2,GT2 A,AT3,GT1 A,AT3,GT2 OR A,AT1,GT1 A,AT1,GT2 A,AT1,GT3 A,AT2,GT1 A,AT2,GT2 A,AT2,GT3 And i want the resultant recordS as A,AT1,AT2,AT3,GT1,GT2 and A,AT1,AT2,GT1,GT2,GT3 Please suggest. write this in user defined sql -----...

ray.wurlod wrote:Disable operator combination to isolate the stage that is generating the error.
Try using casing as per the manual for the function names, for example NullToEmpty(). ...

while reading csv file you have a option Nullabe =yes/No

try that option