DSXchange

DSguru2B wrote:Are your inserts and updates from a single Stage. Or you are splitting the inserts and updates?

They are form a single stage and loaded into the database using upsert method

Hi
I have a job which extracts the data from a stored procedure and upserts it in a table .
I am required to write a log file in unix ,which should contain number of rows inserted and number of rows updated in the table .
I need some suggestion as how to do it
Thanks
Arif

Hi Does any body have an idea what this error is Stored_Procedure_4,0: Error: Sybase datatype not presently supported I am trying to call the stored procedure which takes start date an d end date as input using sel_fls_DSS_extract @begin_datetime = 'MAY-08-2006 09:30:00AM' ,@end_datetime = 'MAY 08 2...

The database is sybase ,stored procedure takes input parameters start_date and end_date from sequential file ,and runs the stored procedure for each input.

Hi I am trying to run a stored procedure with input from a sequential file when I call the stored procedure with transaction size 0 I get teh following error ExecACCTPlanProcedure,0: Error: Deadlock detected: all input links blocked But when I give it something other than 0 I get an error: Stored pr...

Hi
Thanks for your help can you explain the sequence method in more detail ,how to get a list of files and how to how to loop the job processing the files.
Thanks
Arif

I have a job which needs to loop through the files in a directory ,read all the files sequentially in the order which they were created,These files have a time stamp in their name .
Does any body has an idea about it.
Thanks for the help
Arif

Hi guru
I have tried to give the input column name in maps to column in parameter tab,but I am getting error ,is there some changes needed to be done to done to procedure call syntax in the SP stage as well.

I am using the actual stored procedure stage .I dont think it is possible to give an input to the ODBC stage which calls stored procedure.

Hi Ray If the input columns are col1,col2 ...etc. from input files , and the parameters to stored procedure are @ input1,@input2..etc In the syntax to call the procedure Will the syntax of stored procedure be #procedurename#@input1=col1,@input2=col2 or #procedurename#@input1=DSLink.col1,@input2=DSLi...

Hi Ray
I have just bought the membership for charter members ,but still I am not able to view all the contents ,do you have any idea how much time it will take to activate the membership.
Thanks
Arif

Hi
I it possible to give an sequnetial file as input to a stored procedure.I want to pass file data as input to the procedure parameters .
If it is possible then what will be the syntax in stored procedure
Thanks
Arif