Author |
Message |
Topic: IN list several columns |
joergensen
Replies: 1
Views: 2379
|
Forum: Database Posted: Thu Nov 05, 2015 1:52 am Subject: IN list several columns |
how to get this working ?:
select * from tab1 where (col1,col2) in ((1,2),(1,3),(1,4).......)
(select from sysdummy1 with union works, but i think it's a bad solution)
this Works:
select * f ... |
Topic: z/os db2 v9r1 UDF |
joergensen
Replies: 3
Views: 2577
|
Forum: Database Posted: Sun Jan 30, 2011 8:47 am Subject: z/os db2 v9r1 UDF |
count returns integer and the sqlcode=-214 is something about full-select, but difficult to understand
kind regards Ib |
Topic: z/os db2 v9r1 UDF |
joergensen
Replies: 3
Views: 2577
|
Forum: Database Posted: Fri Jan 28, 2011 2:59 am Subject: z/os db2 v9r1 UDF |
hello
I have som problems with this create function and the manuals
lack of gpod examples:
CREATE FUNCTION TEST.JR40151F
( INP1 ... |
Topic: unzip mainframe PGM=UNZIP |
joergensen
Replies: 1
Views: 3676
|
Forum: Utilities Posted: Tue Oct 20, 2009 5:33 am Subject: unzip mainframe PGM=UNZIP |
z5ibj.zip is the achive from windows - transfered with CORE ftp as binary to MVS
z5ibj is my tso user.
then i run this unzip:
//UNZIP EXEC PGM=UNZIP,
// PARM='-v -l -a ''Z5IB ... |
Topic: z/os xml parser |
joergensen
Replies: 0
Views: 2402
|
Forum: Utilities Posted: Mon Oct 05, 2009 6:00 am Subject: z/os xml parser |
I have tryed out plisaxa/plisaxb in my pl/1 program - but have problems with large xml-documents (In my case , it starts with datasets larger than 64 cyls)
so want to use the z/os xml-parser to see i ... |
Topic: contoken in load-modules |
joergensen
Replies: 3
Views: 4338
|
Forum: Database Posted: Wed Nov 05, 2003 2:32 am Subject: contoken in load-modules |
Hello
how do i find the contoken in a load-module (pl/1) . I now how to find it in the db2-environment. how do i identify a contoken
/jorgensenl |
|