Here is the table structure,

CREATE TABLE ProductA_Customer

(

Cust_No_A char(13) NOT NULL,

...

Thanks. I should have noticed it.

That worked. Thank you

I still need help. Please.

I modified my first select statement. The problem was the way I was using the Self Eliminating parameteres.

Instaed of using this clause

(a.car_init = @car_init or @car_init is null)

I used the...

I am not familiar with the Service Broker functionality. Also, is it available in SQL Server 2000.

That explains why it is filling up the log file. If somebody could suggest a solution, I would appreciate it.

Thanks

So I should use char(20) in the Alter statement?

We are a PowerBuilder & SQL Server shop. We have a sister company that develops for handhelds.

I have to develop this procedure for them. They will call this procedure...

Is it possible to get an example.

Thanks

Mike,

Thank you for such a detailed explaination. I will try this and see if it works with my dll.

Thanks again.

The dll is written using VB 6.0 and all the input/output parameters are primitive types.

Are there any examples I can use? I appreciate your help.

Thanks.

David,

The problem is I can have multiple users who create new records.

Is there a way I can pass the user to DB2 and it is the same user

always?

Thanks.