On Mon, Feb 8, 2016 at 1:45 PM, Richard Hipp <drh at sqlite.org> wrote:
> The latest SQLite check-ins contain changes to the SQL language > tokenizer. These changes have been tested on Unicode systems, but we > do not have access to any systems running EBCDIC in order to test > there. If you are deploying SQLite on a computer that uses the EBCDIC > character set, we would appreciate your help in validating the latest > code. > > The "snapshot" at https://www.sqlite.org/download.html contains the > new code, so you can just download and test that. Or, contact me via > private email message if you need further assistance. > > Thanks. > > -- > D. Richard Hipp > drh at sqlite.org ?I downloaded the code to my Linux/Intel box to unzip it. I then uploaded those files to a z/OS 2.2 system, which is definitely EBCDIC based! I was able to successfully compile (eventually) and did some minor tests. Since I was running a session to z/OS from Linux, I was able to capture my input and output using the Linux "script" command. A redacted transcript is below: === Script started on Mon 08 Feb 2016 03:04:36 PM CST Connected to redacted. IBM Licensed Material - Property of IBM 5650-ZOS Copyright IBM Corp. 1993, 2015 (C) Copyright Mortice Kern Systems, Inc., 1985, 1996. (C) Copyright Software Development Group, University of Waterloo, 1989. U.S. Government Users Restricted Rights - Use,duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. IBM is a registered trademark of the IBM Corp. $ cd projects/sqlite-test ~/projects/sqlite-test$ cat source-cflags export CFLAGS='-O3 -V -DSQLITE_MAX_MMAPSIZE=1048576 -qTARG=zOSV1R13 ' export CFLAGS="${CFLAGS} -qLANG=EXTC99 -qFLOAT=IEEE -qnolist -qnosource " export CFLAGS="${CFLAGS} -D_POSIX_C_SOURCE=200112L -D_XOPEN_SOURCE=600" export CFLAGS="${CFLAGS} -DSQLITE_ENABLE_COLUMN_METADATA" export CFLAGS="${CFLAGS} -DHAVE_POSIX_FALLOCATE=0" ~/projects/sqlite-test$ . ./source-cflags ~/projects/sqlite-test$ xlc ${CFLAGS} -o sqlite3 sqlite3.o shell.c FSUM0000I Utility(xlc) Level(D150318.1512) XL_CONFIG=/bin/../usr/lpp/cbclib/xlc/etc/xlc.cfg:xlc ./ ./shell.c *.c "CMDOPTS(DEFINE(errno=(*__errno())),NOTEST,-qoe,-qargparse,-qexecops,-qflag=i,-qhalt=16,-qnodebug,-qnolsearch,-qredir,-qlocale=POSIX,-qlongname,-qmaxmem=*,-qmemory,-qnestinc=255,-qnoexpmac,-qnoexportall,-qnogonumber,-qtarget=le,-qnolibansi,-qlist=/dev/fd1,-qnolist,-qnomargins,-qnooffset,-qnosequence,-qnoshowinc,-qsource=/dev/fd1,-qnosource,-qnoxref,-qterminal,-qnooptimize,-qplist=host,-qspill=128,-qstart,-qnoipa,DEFINE(_OPEN_DEFAULT=1),-qansialias,-qcpluscmt,-qlanglvl=extended,-qnoupconv,-qnoaggregate,-qnoalias,-qnoinfo,-qnoevents,-qrent,-qinline=auto:noreport:100:1000,-qnoinline)" "object(./shell.o)" "OPT(3)" "DEF(SQLITE_MAX_MMAPSIZE=1048576)" -qTARG=zOSV1R13 -qLANG=EXTC99 -qFLOAT=IEEE -qnolist -qnosource "DEF(_POSIX_C_SOURCE=200112L)" "DEF(_XOPEN_SOURCE=600)" "DEF(SQLITE_ENABLE_COLUMN_METADATA)" "DEF(HAVE_POSIX_FALLOCATE=0)" NOPPONLY STEPLIB=NONE _C89_ACCEPTABLE_RC=4 -v -o./sqlite3 sqlite3.o shell.o _C89_ACCEPTABLE_RC=4 _C89_PVERSION=0x42020000 _C89_PSYSIX= _C89_PSYSLIB=CEE.SCEEOBJ:CEE.SCEECPP _C89_LSYSLIB=CEE.SCEELKEX:CEE.SCEELKED:CBC.SCCNOBJ:SYS1.CSSLIB FSUM0000I Utility(c89) Level(D150318.1512) //* c89 ------------------------------------------------------------------------ //LINKEDIT EXEC PGM=LINKEDIT, // PARM='AMODE=31,RMODE=ANY,TERM=YES, // DYNAM=DLL,ALIASES=NO,UPCASE=NO, // LIST=OFF,MAP=NO,XREF=NO,INFO=NO,MSGLEVEL=4, // REUS=RENT,EDIT=YES,AC=0,CALL=YES,CASE=MIXED' //SYSLIB DD DSN='CEE.SCEELKEX',DISP=SHR,DCB=DSORG=DIR // DD DSN='CEE.SCEELKED',DISP=SHR,DCB=DSORG=DIR // DD DSN='CBC.SCCNOBJ',DISP=SHR,DCB=DSORG=DIR // DD DSN='SYS1.CSSLIB',DISP=SHR,DCB=DSORG=DIR //C8920 DD UNIT=SYSDA,SPACE=(32000,(30,30)), // STORCLAS=,MGMTCLAS=,DATACLAS=,DSNTYPE=, // DCB=(RECFM=FB,LRECL=80,BLKSIZE=3200) //C8961 DD DSN='CEE.SCEEOBJ',DISP=SHR,DCB=DSORG=DIR //C8962 DD DSN='CEE.SCEECPP',DISP=SHR,DCB=DSORG=DIR //SYSPRINT DD PATH='/dev/fd1', // PATHOPTS=(ORDWR,OCREAT,OAPPEND),FILEDATA=TEXT, // PATHMODE=(SIROTH,SIRGRP,SIRUSR,SIWOTH,SIWGRP,SIWUSR) //SYSTERM DD PATH='/dev/fd2', // PATHOPTS=(ORDWR,OCREAT,OAPPEND),FILEDATA=TEXT, // PATHMODE=(SIROTH,SIRGRP,SIRUSR,SIWOTH,SIWGRP,SIWUSR) //SYSLMOD DD PATH='./sqlite3', // PATHOPTS=(OWRONLY,OCREAT), // PATHMODE=(SIRWXO,SIRWXG,SIRWXU) //SYSLIN DD * INCLUDE C8920 INCLUDE './sqlite3.o' INCLUDE './shell.o' AUTOCALL C8961 AUTOCALL C8962 /* ~/projects/sqlite-test$ sqlite3 test.db3 SQLite version 3.11.0 2016-02-05 14:11:12 Enter ".help" for usage hints. sqlite> .tables sqlite> create table one(one int); sqlite> insert into one values(1); sqlite> create table two (two text); sqlite> insert into two values('two'); sqlite> select * from one; 1 sqlite> select * from two ...> ; two sqlite> insert into one values('ugly'); sqlite> select * from one; 1 ugly sqlite> .quit ~/projects/sqlite-test$ exit logout Script done on Mon 08 Feb 2016 03:07:41 PM CST ===? -- The man has the intellect of a lobotomized turtle. Maranatha! <>< John McKown
