A long time ago I wrote a cobol equivalent because the site didn't have a PL/I compiler and the program was distributed in source only. Lacking the necessary naming expertise I simply called it CSNTEP2 with the first character indicating the language used :). It might still be available at IDUG code share site. Regards Khalid
On Mon, 28 Nov 2022 23:48:05 +0000, Farley, Peter <[email protected]> wrote: >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 <[email protected]> On Behalf Of >Bernd Oppolzer >Sent: Monday, November 28, 2022 5:50 PM >To: [email protected] >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 23737 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: [email protected] >> 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 [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
