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
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