DSXchange

Hi All, I transferrred my job from one project to other new project in same server..and this is first time iam running a job in this project.. i was getting following error.... Stored_Procedure_93,0: Error: ORA-12154: TNS:could not resolve the connect identifier specified Stored_Procedure_93,0: Erro...

You cannot if you want to leverage a bind parameter like that, I'm afraid. Where are you trying to do this, on the source or target side? What are you trying to bind into that :1 spot? Hi chulett, actually i went through dsxchange for calling a function and found this syntax. Can you tell me how to...

chulett wrote:That would need to be in a reference lookup for that parameter binding to have a chance to work correctly - are you? ...

No chulett,

I want to call just function with output argument with out lookup....

chulett wrote:That would be correct. It may work (never tried) but you'd have no mechanism to capture the output. ...

Thanks chulett..

Hi All, How can i call function with output argument in oracle stage as function(output); i tried calling select function(':1') from DUAL; Iam getting following error... main_program: aptoci.C:446 failed. Message: ORA-00911: invalid character Query failed: SELECT function(':1') from DUAL; ; Oracle E...

chulett wrote:You can't, at least not there. You should be using the Stored Procedure stage for that. ...

Hi Chulett,

So we can execute simple procedures with input args or no args in an OCE but we cannot execute procedure output arguments.

Is this valid senetece..

Thanks...

Hi All,

I have a procedure which gives output , like
procedure(out).

How can i test in OE stage using open command..

For out , how should i capture the output column..

Thanks...

Hi All, I was using stored procedure which takes 11 parameters out of which 10 are input to procedure and one is output... For output column should we declare the column before stp stage....because its not allowing me to define output column?? If we should define before what value should we set to i...

CFF is used for reading sequential files with "structures". Good examples are multi-level COBOL generated files (you'll need the copybook to set it up easily) or files that have different types of record layouts indicated by a flag field in the first column (typically Header / Detail / Tr...

Hi All,

Does CFF Stage in 7.x is used to seperate records from file having different record types?

I couldnt find any options for seperating records...

Is there any difference between CFF stage in 7.x and 8.x?

Thank you...

anbu wrote:Your file system may be full.

Run this command and check whether you have free space in your file system.

Code: Select all

/bin/df

Hi anbu

After executing command

in /home it says used 100%

is this my disk is full...

If so how to free the space..

Can i remove all files from Scratch dir..

When i checked ulimit from inside job

it gave
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 2097152
stack(kbytes) 4194304
memory(kbytes) unlimited
coredump(blocks) 16384
nofiles(descriptors) unlimited

Any suggestions..

kandyshandy wrote:Check the file name in the sequential file stage. You may have passed some parameter without #...# or some typo.

Filename was correct .

i gave full path

xxx/xxx/xxx.dat

Output file is only 83MB.

but getting this error...

Any suggestions..

Hi All, While writing to sequential file iam getting following error.. CFO,0: Export failed. CFO,0: Output file full CFO,0: Fatal Error: No file descriptor was supplied. node_node0: operator [APT_RealFileExportOperator in CFO], partition 0 of 1, processID 2,441,310 on node0, player 18 terminated une...