MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 6 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: IN list several columns
joergensen

Replies: 1
Views: 2379

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group