 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 15 matches |
| Author | Message |
|---|---|
 Topic: Position and substring query Problem\Question |
|
| cappertan Replies: 3 Views: 1522 |
 Forum: Database Posted: Thu Jan 31, 2008 2:52 pm Subject: Position and substring query Problem\Question |
| Kolusu:
Yes. Your output sample is correct. That is what I want. Thanks for quick reponse to my post. Capp |
|
| Topic: Position and substring query Problem\Question |
|
| cappertan Replies: 3 Views: 1522 |
Forum: Database Posted: Thu Jan 31, 2008 12:30 pm Subject: Position and substring query Problem\Question |
| Hi:
The following query below works but I am stuck as how to get the final results, if possible. If I have found 'LEFT VENTRICLE' then I want to get the percentage '40-45%'. I need to have the perc ... |
|
| Topic: QMF error: NIL MEMBER FOR IRCP DEFAULT |
|
| cappertan Replies: 1 Views: 1056 |
Forum: Database Posted: Sat Oct 27, 2007 1:17 pm Subject: QMF error: NIL MEMBER FOR IRCP DEFAULT |
| Hi:
I have a batch production job down with the error describe in the subject. This is what display in the output. 'PASFRIRPT' is the report. I was told that having QMF objects (queries, procs, ... |
|
| Topic: SQL Help for finding a date + nn days |
|
| cappertan Replies: 1 Views: 969 |
Forum: Database Posted: Wed Jan 25, 2006 11:17 am Subject: SQL Help for finding a date + nn days |
| Hi:
After reading posts, I am still confused. I think I am close but do not have the syntax right. *** My goal is to find all date greater than that date + 84 days. Beg_dt are dates in my test dat ... |
|
| Topic: varchar key with COBOL to DB2 |
|
| cappertan Replies: 2 Views: 1530 |
Forum: Database Posted: Wed Feb 16, 2005 10:12 am Subject: varchar key with COBOL to DB2 |
| HI:
I want to do a DB2 read with cobol using a varchar key of 18. My cobol WS layout is: 01 key. 49 key-comp pic S9(04) comp. 49 key-first-9 pic x(9). 49 key-rest-9 pic ... |
|
| Topic: Cobol SQL and read-in timestamp |
|
| cappertan Replies: 1 Views: 1610 |
Forum: Database Posted: Wed Sep 08, 2004 3:34 pm Subject: Cobol SQL and read-in timestamp |
| I have code that is giving me a Declare error, however, it does compile.
select * FROM PAT_ENC WHERE CAST (UPDATE_DATE AS DATE) >= CONTACT_DATE AND C ... |
|
| Topic: Date Comparison using Date type function? |
|
| cappertan Replies: 2 Views: 1400 |
Forum: Database Posted: Thu Sep 02, 2004 9:33 am Subject: Date Comparison using Date type function? |
| Thanks Kolusu. I will give it a go. | |
| Topic: Date Comparison using Date type function? |
|
| cappertan Replies: 2 Views: 1400 |
Forum: Database Posted: Thu Sep 02, 2004 7:50 am Subject: Date Comparison using Date type function? |
| I am looking for an example to a query to find
ID's where the UPDATE_DT >= CONTACT_DT. contact_dt is defined as YYYY-MM-DD up_dt is defined as yyyy-MM-DD HH:MM:SS. Example: Select * from t ... |
|
| Topic: Querying a float defined number |
|
| cappertan Replies: 5 Views: 5126 |
Forum: Database Posted: Thu Aug 12, 2004 10:50 am Subject: Querying a float defined number |
| Column Definition:
COLNO COLTYPE LENGTH ------+---------+------ 12 DOUBLE 8 Entire query: ***************************** Top of Data ** SELECT A.PAT_ID, ... |
|
| Topic: Querying a float defined number |
|
| cappertan Replies: 5 Views: 5126 |
Forum: Database Posted: Thu Aug 12, 2004 10:35 am Subject: Querying a float defined number |
| Kolusu:
No calculations. Just trying to find rows where this is greater than 0. I tried NOT Null but got the same error. Will check the IBM site. |
|
| Topic: Querying a float defined number |
|
| cappertan Replies: 5 Views: 5126 |
Forum: Database Posted: Thu Aug 12, 2004 9:58 am Subject: Querying a float defined number |
| Hi:
1. I am trying to run this query: WHERE A.PAT_ID > ' ' AND A.PAT_ID = B.PAT_ID AND BP_SYSTOLIC > 0 I get a systax error of : DSNE610I NUMBER OF ROWS DISPLAYED IS ... |
|
| Topic: Easytrieve, remote binds and Teradata |
|
| cappertan Replies: 0 Views: 829 |
Forum: Database Posted: Thu Aug 05, 2004 8:47 am Subject: Easytrieve, remote binds and Teradata |
 Hi all:
Has anyone any information on or who to contact concerning compiling/remote binding Easytrieve on Teradata on a server? Has anyone doing this currently? The CA web site does not show Te ... |
|
| Topic: Easytrieve SQL format to access table via UDB |
|
| cappertan Replies: 5 Views: 4846 |
Forum: Application Programming Posted: Wed Jul 21, 2004 3:40 pm Subject: Easytrieve compiling to access Teradata dbms on udb |
| Kolosu. Hi:
Is this an issue for concatenation as well? We, at my shop, are migrating to Teradata dbms. Since we are running Teradata on a windows based server, access will be via UDB or another m ... |
|
| Topic: Easytrive Field Def for A Float |
|
| cappertan Replies: 1 Views: 1060 |
Forum: Application Programming Posted: Fri Jul 09, 2004 9:56 am Subject: Easytrive Field Def for A Float |
| Hi:
I checked the Ezt manual but I did not see how to hand a number defined on the database as a Float. In SPUFI, I can use the expression DECIMAL(AGE,3,0) AS AGE. I will want to specify numbers ... |
|
| Topic: Easytrieve SQL format to access table via UDB |
|
| cappertan Replies: 5 Views: 4846 |
Forum: Application Programming Posted: Thu Jun 24, 2004 11:59 am Subject: Easytrieve SQL format to access table via UDB |
| I want to access a table that I am connecting to via UDB. In my SQL, in Easytrieve, would I code something like? :
SELECT PAT_ID, DEPARTMENT_ID FROM HCCLDCO1.HCCLCO.PAT_ENC HCCLDCO1 is the ... |
|
All times are GMT - 5 Hours |