|
 |
|
|
| |
|
COBOL Language [
return
] |
|
From |
Message |
kzlimboo
9/27/2005
05:30:04
|
 Subject: Dynamic SQL
Message:
Hi,
I need to embed Dynamic Sql in a Cobol program in Mainframe enviroment.Please let me know how can it be done.
Thanks,
KL
|
blindzz
9/27/2005
06:21:04
| RE: Dynamic SQL
Message:
http://www.db2mag.com/story/showArticle.jhtml?articleID=15300107
Describes the pieces for using DB2.
|
blindzz
9/27/2005
06:23:46
| RE: Dynamic SQL
Message:
Oops didnt see dynamic..sorry
|
kishor
9/27/2005
06:45:37
| RE: Dynamic SQL
Message:
Hi,
FOR DYNAMIC SQL FOLLOW THE STEPS AS GIVEN BELOW:-
1.DECLARE A VARIABLE AS
“DAYSQL PIC X(80) AS REQUIRED BY YOU”
2.MOVE THE SQL STATEMENT TO THIS VARIABLE AS SHOWN BELOW
MOVE “INSERT INTO EMP (EMPN , EMPNAME)
VALUES (:V1, :V2)” TO DAYSQL-ARR
MOVE 50 TO DAYSQL-LEN
3.PREPARE THE SQL STATEMENT .
EXEC SQL
PREPARE S FRPM :DAYSQL
END-EXEC
TILL NOW PREPARATION OF SQL STATEMENT IS DONE AND VALUES FOR V1 AND V2 HAS TO GIVEN AT THE TIME OF EXECUTATION.
4.EXECUATE THE DAYNAMIC SQL
EXEC SQL
EXECUATE S USING :ENPN , :EMPNAME
END-EXEC
KISHOR PATHAK
kishorpathak@rediffmail.com
|
|
|
|
|
|
|
|
|
|
|
[ Go to Top of Page ]
|
|
|
|
COBOL Forums |
Do you need COBOL help?
Let the COBUG members help you.
Post your issues!
|
|
|
New Local User Group |
Welcome!
COBOL User Group - Trivandrum (CUGTVM), India
|
|
|
COBOL Jobs |
Here are references to a wealth of
COBOL job resources.
|
|
|
Job and Resume Matchmaker! |
Employers submit your COBOL job openings.
Job seekers submit your resumes.
|
|
|
