home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 8 Other
/
08-Other.zip
/
tblcp2.zip
/
tblcop2.CMD
next >
Wrap
OS/2 REXX Batch file
|
1993-10-28
|
722b
|
40 lines
/* Rexx */
fromdb = 'sample'
cmdstr = "return dbm('alter table new_col_list primary key(name,tbname,tbcreator)')"
/*cmdstr = ''*/
lituid = 'userid'
litpw = 'password'
litlu = '*'
littab = 'sysibm.syscolumns'
commitfreq = 100
s.0 = 1
s.1.1 = litlu
s.1.2 = 'sample'
s.1.3 = 'new_col_list'
s.1.4 = lituid
s.1.5 = litpw
s.1.6 = 'replace'
s.1.7 = 'reject'
s.1.8 = 'y'
s.1.9 = 'y'
s.1.10 = ''
s.1.11 = cmdstr
ss = 'select * from' littab 'for fetch only'
If rxfuncquery('tcopy') then
call rxfuncadd 'tcopy','tblcop2e','tblcop2e'
say tcopy(fromdb,ss,'s.',lituid,litpw,commitfreq)
Do i=1 to s.0
Say;Say 'Result from partner #'i'('s.i.1'/'s.i.2'):'
Say s.i
End
Exit