Tuesday, July 28, 2009

(Q&A) What is the Difference if I do the RESET or not?

(From : Oyie)

The CONNECT RESET statement is used to connect to a local database, you can use this if your AS/400 is not yet connected to any SQL servers. By default AS/400 is connected locally, therefore you don't need to execute CONNECT RESET in your program.

Example:
Try using DISCONNECT CURRENT to disconnect to your database, then issue CONNECT RESET to re-establish database connection.

C/EXEC SQL
C+ DISCONNECT CURRENT
C/END-EXEC

C/EXEC SQL
C+ CONNECT RESET
C/END-EXEC


1 comment:

  1. HELLO, friend. I enjoy pouring through your post. Keep up with your smile and spread the virus of JOY...this lightens up the load of challenges we face each day.

    ReplyDelete