If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2CLP commands in the same window!

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-08-04, 11:15
vsodhi vsodhi is offline
Registered User
 
Join Date: Jul 2004
Posts: 1
DB2CLP commands in the same window!

I need a way to keep my current DB2 CLP window open so i can execute the following commands in the same window.

I execute the following commands using Create Process:

catalogTcpip.Format(_T("DB2CMD.exe -c -w -i db2 catalog tcpip node CNS remote %s server 1527"), serverName);
catalogDummy.Format(_T("DB2CMD.exe -c -w -i db2 catalog db dummy at node CNS authentication server"));
connectDummy.Format(_T("DB2CMD.exe -c -w -i db2 connect to dummy user app using app"));
createDb.Format(_T("DB2CMD.exe -c -w -i db2 call CREATE_DB('%s')"), dbName);
My problem is that after it goes and connects to the dummy database and then i call a function from my stored procedure called "Create_DB", it says that the connection does not exist.

I need a way so that the DB2CLP does not go away after it connects to the database and keeps the connection for the commands that i run after it.

Please let me know what I can do here.

Thanks,
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On