DSXchange

can you tell which solution worked for you?

you will need to create a counter to keep track of the files alredy processed. you can create one in a table or in a file.

I have the following fatal error when running a job:

buffer(3),0: APT_BufferFile: unable to create file 000000000000001c: No such file or directory
APT_BufferFile: unable to create file 000000000000001d: No such file or directory

however, the job doesn't abort.

Got the solution from this post:

viewtopic.php?t=106291&highlight=

ray.wurlod wrote:Generate a column containing the column names (as constants) upstream of the Pivot stage.

Hi Ray,
can you elaborate on how the column names can be matched up with the correct value?
Thanks

ray.wurlod wrote:Generate a column containing the column names (as constants) upstream of the Pivot stage.

Hi Ray,
can you elaborate on how the column names can be matched up with the correct value?
Thanks

I have a file in the following format: co1 col2 col3 row1 data11 data12 data12 row2 data21 data22 data23 row3 data31 data32 data33 the data should be modified: row1 col1 data11 row1 col2 data12 row1 col3 data13 row2 col1 data21 row2 col2 data22 the number of columns is dynamic. i tried 'make subreco...

I have a file with variable length rows

i.e.:

val1:data1;val2:data2;val3:data3
val4:data4
val5:data5;val6:data6

i need to split values and data, such that all values are in one string and all data in the other

Please advise on the ways to do it

Are you able to execute the stored proc. successfully and capture the OUT parameter from your favourite sql tool. when i execute the sp from sqlplus, i have to define a variable: sql> variable v refcursor sql> exec stor_proc (in_par1, in_par2, :v) it works; and to see the result: sql> print v

DSguru2B wrote:Read about stored procedure calls in ODBC help guide. I am pretty sure OUT parameter is not supported. But I can be wrong.

but even when i use STP stage I get the same errors.

DSguru2B wrote:What kind of variables are these? I think ODBC stage can only support IN and IN/OUT parameters for stored procedures. Do you have STP stage?

there are two IN variables, and ref cursor is OUT

i am using ODBC stage to call a stored procedure. it has 2 input parameters and an output ref cursor. i used manager to define metadata, but it only shows two input parameters. when i call the procedure with just 2 input parameters, it gives me error: ORA-06550: PLS-00306: wrong number or types of a...