Hi,
I have the following stored procedure
CREATE PROCEDURE SEARCH_CRUISE_DEBUG33(
)
RESULT (
CruiseId VARCHAR(10000)
)
BEGIN
String resultString = null ;
// Businees logic to populate resultString.
SQLResultSet.set(1, resultString);
SQLResultSet.insert();
END
The length of...
Hi ,
I am new on Java Stored Procedure. Our application is a java based application connecting to progress DB.
Below is a sample of stored procedure we write. I want to set isolation level to Read Uncommitted. With out that, its creating share locks. Can any one tell me how to set isolation...
HI,
I am a junior progress resource.
In our development environment, in appserver log , we are getting entries like
AS AS Server Message state = MSGSTATE_INITRQ
AS AS Server Message state = MSGSTATE_RECVLAST
requestID= <REQ|2391c70de6acfedc:-4a57888b:13776dacd49:-7ff8-001267>
AS AS -- TRACE...
Help need on colon "::"
Hai,
Can you help me whats the meaning of using ::
Can you please tell any pdf or something where i can get more information on it.
I have seen in some places its used like
Prodataset-handle::buffer-handle.
Hai,
I need to find the number of records in a buffer which satisfies a given where condition.
for example :
i have a query
h_query:query-prepare("for each compinv").
i need to find the number of records.. There is a function called h_query:num-results.but this needs the query to be opened...
Hai,
I got a temp-table t-t1 and t-t2. both having similar signature.
now t-t1 has one record and t-t2 has another record.
i want to write a for each statement such that it will fetch record from t-t1 and then from t-t2.
Is this possible to do without copying data from both to one temp-table.?
Hai,
Is there anyway to get the primary unique key of a buffer from its handle.
there is a statement like
hbuff:index-information(i).
but that gives information of all the indexes for different values of i. but that is a over load as i have to loop through it.
is there any easier way? it...
hai,
Is there anyway to identify whether a temp-table or dataset is passed as by-reference to the called procedure, from the called procedure...
For example...
run test.p(input dataset d-data by-reference).
/* prodecure test.p) */
input parameter dataset-handle h-data).
i want to know...
Hai,
I am a beginner in progress.. Please help me in following situation.
define variable v-where as char.
assign v-where = "tbprihdr.price-id = 1234".
find first tbprihdr where price-id = 1234.
message price-id. /* the record is available in buffer. */
if v-where then message...
Hai,
I am facing a problem.
i was compiling the following piece of code
def new shared temp-table tt-temp like hoteldsc.
def new shared dataset d-date for tt-temp.
but i got the error
Buffer tt-temp in shared dataset d-date must be shared too. (12383)
** Could not understand...
Hai
I am new guy on progress. only 2 months of experience.I am facing a problem and it will be great help if someone can get me a solution.
The problem is , i am getting the following error.
SYSTEM ERROR: Memory violation. (49)
** Save file named core for analysis by Progress Software...
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.