Search results for query: *

Frederico, The customer is quite happy with the batch option - so I've moved on to other tasks. Rick

Frederico, I don't have all the facts - it's a IBM Z/OS operating system, using Oracle's PRO Cobol (version 10.1). As I've stated previously, I can produce a report with all SQL*Plus features, control breaks and headings, column name changes, report titles, computes etc. I can do this running a...

Chris, Thank you for your response - a table variable is what I was looking for. Frederico: You have been following me around every since I started posting, making assumptions and alway sending me links. I was a member previously (under a different handle), circa 2002 (for almost 8 years) and...

I have the following SQL*Plus query (executed via a Cobol program) that I'd like to output to a Table: REPHEADER CENTER 'CUSTOMER NAME AND ADDRESS' SKIP2 COLUMN CLIENT_ID HEADING 'CUSTOMER #' COLUMN CUST_NAME HEADING 'CUSTOMER NAME' COLUMN ADD_1 HEADING 'ADDRESS LINE 1' COLUMN ADD_2...

Frederico, I think you can do that - if you look at the example I posted the PL/SQL proc is being executed from SQL*Plus. The PRINT RC does that (RC is a REF CURSOR). Here's another example below, although this one does not do any special formatting. QL> create or replace function get_emps(dno...

One more thing Dave .. The example I posted in response to Federico's reply - I got this off the net! It's SQL Developer, I'm looking for something similar for my needs. Thanks, Rick

Dave, Thank you. I have already done this in my Batch processing, it works fine. I can do control breaks, report breaks, column heading changes, report titles, formatting etc. The caveat here is that the user has to logon to TSO to check the output - painful!. I want to provide them with a...

I am working on a CICS Cobol project where users enter SQL*Plus (Oracle) statements, the system is expected to return the result sets on-line or Batch. I got the batch part working - the on-line is another matter. I have done a lot research without success. Here's an example of how it's done in...

Frederico, Thank you for your response. I have been through this link but have not found what I've been looking for. Here's what I want to accomplish using Cobol on the Mainframe dynamically: VARIABLE rc REFCURSOR BEGIN OPEN :rc FOR SELECT DEPARTMENT_NAME, LAST_NAME, SALARY FROM...

I am new to Oracle and would greatly appreciate any help with this. I am working on a Cobol CICS project where users enter SQL*Plus statements and submit for execution via Batch or On-line mode. My Batch mode works perfectly with control breaks, headers and footers. My problem is accomplishing...