a little SQL help please 1

[Bastien]

Hi All,

Stuck with a db2 sql query...(using ASP/VBScript to write the query)

  sSQL = "update form_header set form_status ='" & sStatus & "', form_name = form_name ||'_del_'||current time where form_id = " & sFormID

error is

update form_header set form_status ='2', form_name = form_name ||'_del_'||current time where form_id = 151
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[IBM][CLI Driver][DB2/NT] SQL0440N No authorized routine named "||" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884

/apiss250/bastien250/PortalAdmin/Core/admin_config_form.asp, line 1944

Help please

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[ddiamond]

You need to convert current time to a string. The || operator only works with strings.

 

[cristi22]

The following syntax I've used for the date
'(''' || char(date_to) || ''') '

string:

(''' || LTRIM(RTRIM(in_fund)) || ''' )

 

[handle1969]

Hello Bastien,
I am here to implore you the following favour.


I have installed in my pc db2 and vb.net

I have created a db also in db2.

I am in need of making a connection through odbc to a db of db2.
I am in need of the correct components and the connection string.

Can u pls help me?
Thanks.

 

[ddiamond]

Handle,

see thread178-1202356.