I am on a Solaris running Oracle 9i and am running a third party interface (Inglenet) to access Oracle. We are trying to implement a new interface, our own. I want to write the calls in "C" using OCI and Connetion Pooling, but do not know how to implement this. I have read the Oracle...
I am new, so please forgive my ignorance. I am trying to output data with leading spaces, this is truncated.
dbms_output.put_line(lpad('CREATE: ',30||mydate));
it displays as:
CREATE: 20040101
instead of
CREATE: 20040101
Why is this happening?
Thanks
Bill Pendleton
We are using Microfocus Cobol on Unix (Solaris). I am trying to write a socket interface to another machine that passes data to us for name searching. We are migrating to Unix from a mainframe. Could someone help?
Thanks,
Bill
Thanks Dave,
I am very new to Oracle, though I have done years of SQL. Where do you store the script and get it to execute? I see you are using an "@" infront, why is this?
Bill
I am dumping data for our conversion to Oracle, to compare to data dump on our old mainframe. How can I dump the data vertically, I may have 60 columns of data which is very hard to read.
e.g. Select * from Table;
I get:
field1|field2|field3
data1 |data2 |123123.000
would like:
field1 =...
I am new to RDMS.
I have a Select where the Column is wider than the data.
SELECT data1, data2 FROM jobq;
I get:
data1 data2
------------------- -------------------
item1 item2
item1a item2a
would like to shorten width to be:
data1 data2
-------...
I am new to Microfocus Cobol, am used to mainframe cobol. Is it possible to run a Unix Script? I know "C" can execute scripts, but can Cobol?
Thank for any help!
Bill
I have done this and do not have a problem. Let us see your code.
Here is mine.
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
<title>Test CSS</title>
</head>
<style type="text/css">
h1 {font-family: Verdana; color...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.