Page 1 of 1

can DB2 be called by HLASM directly?

PostPosted: Mon May 06, 2013 1:16 pm
by bobguo
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

Re: can DB2 be called by HLASM directly?

PostPosted: Mon May 06, 2013 2:54 pm
by enrico-sorichetti
YES, YES, NO ...

look Yourself at DSNxxx.SDSNSAMP(DSNTIAD)

Re: can DB2 be called by HLASM directly?

PostPosted: Mon May 06, 2013 7:15 pm
by bobguo
DSNxxx.SDSNSAMP(DSNTIAD)?

where can i find it?

Re: can DB2 be called by HLASM directly?

PostPosted: Mon May 06, 2013 7:37 pm
by enrico-sorichetti
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

Re: can DB2 be called by HLASM directly?

PostPosted: Mon May 06, 2013 8:33 pm
by Robert Sample
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.

Re: can DB2 be called by HLASM directly?

PostPosted: Wed May 15, 2013 5:34 am
by bobguo
what i want to know is how to implement it in our source code?

Re: can DB2 be called by HLASM directly?

PostPosted: Wed May 15, 2013 6:30 am
by steve-myers
Did you look at DSNxxx.SDSNSAMP(DSNTIAD) as an example of how to do it?

Re: can DB2 be called by HLASM directly?

PostPosted: Wed May 15, 2013 8:17 pm
by dick scherrer
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 . . .