Search results for query: *

It will not compile successfully. I am using sql developer and there is a red squiggly line under "RefCursorType) IS" from the following: CREATE OR REPLACE PROCEDURE zgetWorkOrderDetail (i_dispatchId IN dispatch_interaction.confirmation_number%TYPE...

When I compile it I get the following error PLS - 00103: Encountered the Symbol "Exception" when expecting on of the following....

In the procedure below myItc will return a single value of a dblink which is stored in a table. I want to then use it to dynamically query a table using the link(as in the lines that are commented out). How do I do it through a procedure? CREATE OR REPLACE PROCEDURE getWorkOrderDetail...

I believe it is your date format. Look at the .mas for PROJECT_TIME.TIMEDATE, it is probably date-time format. The way to fix the problem is to define a new date field and then base your selection off that field. for example - if it IS a date-time field: DEFINE FILE STAFF...

Quick and dirty: table the first file and 'hold' to a hold file filedef the hold file with append table the second file and 'save' to the hold file report off the hold file ie: table file car print country on table hold as hcar end filedef hcar disk hcar.ftm (append table file car2 print...

Check the .mas of the second file. Does it create a foclist field. If so, it will blow up at 100000. Try adding this to your focexec: SET COUNTWIDTH = ON It will increase this to 999999999.

Yes...

Problem: User needs to select a street name from a table of over 700,000 records. To populate the dropdown list of distinct values takes too long to process. Is there a way to narrow down the DB query for the list box based on the first character(s) the user keys into the selection box?

Set all = on

To better assist, I need an example of the data. There are two ways to handle reading the file. SAMPLE DATA: test.dat 1abc9999999999 20000aaaaaaaaaaaa 1cdf8888888888 29393llllllllllll 1dkd8383838383 1iej8383838281 29342oweselcoekco As you can see there are two different records within this...

Simple. As long as you have a master file description and access file for your oracle table (ie oracletb.mas oracletb.acx) then you can create a simple modify to update the database. In the example below, field1, field2, field3 make up the unique key to the table (as defined in the oracle...

-SET &PARAM2 = &PARAM1 + 10;

I do not work for IBI. I have not had any experience with a mainframe but my environment seems to be similar. I have my web server on one NT box. I have my webfocus server on another NT box. I am accessing oracle data that is on HP and IBM servers (unix). All that you need to do is load...

It depends on: what you are using the edaserver for? What it is accessing? What it is executing?

table file xxxx print lastname as 'last name' firstname as 'first name' service_date by lastname noprint by firtsname noprint end The report will be sorted properly and all values will be displayed...