OK, so you are suggesting "DSN" as the prefix, "T" for Test or Training in the fourth position, something else for the fifth character (or maybe Tx as a 2-character meaning of some kind in 4 and 5), and A/C/P for the language in the sixth position. I can see that as a reasonable explanation. Would be nice if IBM revealed their naming convention somewhere, like maybe in the sample library itself?
Thanks for your insight. Peter -----Original Message----- From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of Bernd Oppolzer Sent: Monday, November 28, 2022 5:50 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Origin of the name of sample programs DSNTEP2/4? Hello Peter, IMO, the P in the name DSNTEP2 is because it is written in PL/1. There are some other sample programs like DSNTIAD and DSNTIAUL, which are written in ASSEMBLER, that's why IMO the 6th letter depends on the programming language. DSNTIAUL is heavily used at my customer's site to do unloads of SQL results for archiving and testcase construction purposes. BTW, I wrote a replacement for DSNTEP2 and DSNTIAUL, which does the same as the two programs do and much more, but I wrote it in C. It also runs on the non-mainframe platforms and there exists a version for Oracle, as well. And because it also supports Load (not only Unload, like DSNTIAUL), it can be used to transfer data between all flavors of DB2 and Oracle, on all platforms :-) This is great for everyone who wants to do ETL jobs on sites with a mix of DB2 and Oracle databases. If you want to know more, call me offline. Kind regards Bernd Am 28.11.2022 um 23:37 schrieb Farley, Peter: > Cross posted to IBM-MAIN. > > I asked this question earlier today over on DB2-L (the one run by IDB2UG), > but it later occurred to me that someone here might also know the answer to > my question. > > Peter > > _____________________________________________ > From: Farley, Peter > Sent: Monday, November 28, 2022 3:08 PM > To: idb2ug-d...@connectedcommunity.org > Subject: Origin of the name of sample programs DSNTEP2/4? > > > Just a question of curiosity - Does anyone know where the names for the DB2 > PLI sample programs DSNTEP2 and DSNTEP4 came from? Is it as simple as (DB2 > prefix DSN) + (TEst Program 2/4)? > > Also, if anyone is interested I have a modified copy of DSNTEP2 that > implements full PARM/PARMDD processing (up to the PARMDD max of 32760) for > all "functional comment" overrides and a new SYSDATA option that writes all > SELECT output to a new file with just one record per returned row and a > single instance of the column headings (suitable for post-processing into CSV > or other formats). Write to me **privately** please (pjfarley3 at earthlink > dot net) and not to this list or to this work email address if you are > interested. > > I would contribute the changes to CBTTAPE.ORG but the original DSNTEP2 code > is copyrighted by IBM. > > Peter -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
