MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 3 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: execute insert query through REXX
Packi

Replies: 4
Views: 3113

PostForum: TSO and ISPF   Posted: Mon Jan 07, 2008 6:05 am   Subject: execute insert query through REXX
SQL6=Insert into table2 (select * from table1 where not exists(select * from table2 where table1.keyfield1 = table2.keyfield1))

...
  Topic: execute insert query through REXX
Packi

Replies: 4
Views: 3113

PostForum: TSO and ISPF   Posted: Thu Jan 03, 2008 7:36 am   Subject: execute insert query through REXX
I need to execute the following sql query through REXX:

Insert into table2 (select * from table1 where not exists(select * from table2 where table1.keyfield1 = table2.keyfield1))

i tried dynamic ...
  Topic: Moving Null Values to table fields
Packi

Replies: 3
Views: 3753

PostForum: Application Programming   Posted: Thu Jul 05, 2007 1:19 am   Subject: Moving Null Values to table fields
what would happen if we move Null Values or Spaces to a table field through a cobol program?
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group