IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


can DB2 be called by HLASM directly?



High Level Assembler(HLASM) for MVS & VM & VSE
Post a reply

can DB2 be called by HLASM directly?

Postby bobguo » Mon May 06, 2013 1:16 pm

as asked by subject: db2 can be called by hlasm directly?

or 'sql sentences' can be written in HLASM?

can somebody give me one sample program? thanks
bobguo
 
Posts: 76
Joined: Thu Apr 26, 2012 11:18 am
Location: shanghai
Has thanked: 22 times
Been thanked: 0 time
Top

Re: can DB2 be called by HLASM directly?

Postby enrico-sorichetti » Mon May 06, 2013 2:54 pm

YES, YES, NO ...

look Yourself at DSNxxx.SDSNSAMP(DSNTIAD)
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3006
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 165 times
Top

Re: can DB2 be called by HLASM directly?

Postby bobguo » Mon May 06, 2013 7:15 pm

DSNxxx.SDSNSAMP(DSNTIAD)?

where can i find it?
bobguo
 
Posts: 76
Joined: Thu Apr 26, 2012 11:18 am
Location: shanghai
Has thanked: 22 times
Been thanked: 0 time
Top

Re: can DB2 be called by HLASM directly?

Postby enrico-sorichetti » Mon May 06, 2013 7:37 pm

where can i find it?

probably in a cabbage :geek:
what kind of dumb question is this one ... :evil:


use a bit of ingenuity
DSN ==> is the dstandard DB2 HLQ prefix
xxx ==> 910 for example is the Version id for DB2 9.1
SDSNSAMP is the .. the name hints the db2 samplib.

ask Your support about it
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3006
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 165 times
Top

Re: can DB2 be called by HLASM directly?

Postby Robert Sample » Mon May 06, 2013 8:33 pm

DSNxxx.SDSNSAMP(DSNTIAD)?

where can i find it?
Since data set names can be customized during software installation, only someone working at your site can tell you absolutely for sure what the data set name will be for your site. While you were provided the default installation name, if your site customized data set names then you need to contact your site support group to find the SDSNSAMP file.
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times
Top

Re: can DB2 be called by HLASM directly?

Postby bobguo » Wed May 15, 2013 5:34 am

what i want to know is how to implement it in our source code?
bobguo
 
Posts: 76
Joined: Thu Apr 26, 2012 11:18 am
Location: shanghai
Has thanked: 22 times
Been thanked: 0 time
Top

Re: can DB2 be called by HLASM directly?

Postby steve-myers » Wed May 15, 2013 6:30 am

Did you look at DSNxxx.SDSNSAMP(DSNTIAD) as an example of how to do it?
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times
Top

Re: can DB2 be called by HLASM directly?

Postby dick scherrer » Wed May 15, 2013 8:17 pm

Hello,

If you do not know what DSNxxx.SDSNSAMP(DSNTIAD) is and you don't know where to find it, you should ask your DB2 support.

I did a 3.4 dataset search and found all of ours in a few seconds . . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times
Top
Post a reply

Return to Assembler

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks