Pro*C is an embedded SQL programming language used by Oracle Database and Sybase SQL Server database management systems.
0
votes
0answers
7 views
SAS Proc SQL get records with nearest date to a specific date
I have 2 tables as belows:
Table 1, a user listing table:
Year Month Id Type
2010 3 1 A
2010 5 2 B
2010 10 1 A
2010 12 1 A
Table 2 describes user promotion history:
...
2
votes
2answers
112 views
SAS proc sql concatenation and join like
I'm trying to build a data model in SAS structures for Financial System Data. The idea is to keep IDs in a table as character expression and then build a proc sql with inner join to them from another ...
0
votes
1answer
61 views
How to call Pro*C Code from JAVA?
Currently I am working on a project where I need to migrate Oracle forms application to Java web application. There are some forms which calls Oracle Pro*C code for inserting and updating records to ...
0
votes
2answers
59 views
Using LIKE with pro*c
How do I use LIKE with pro*c? The code below don't worked. I need to search records in database.
cout<<"Employee name\t\t: ";
cin.getline(name,50);
EXEC SQL SELECT NAME INTO :nameResult FROM ...
0
votes
0answers
29 views
Input data not assign to sql query
The sql update below will not work but it will update if I comment out "cin name" at employee update. I don't understand because I already asked for employee name during employee search so the name ...
1
vote
2answers
142 views
why does the MAX function strip the SAS variable format in proc sql?
Consider the following:
data;
format x datetime19.;
x=datetime();
flag='FIRST';
do x=datetime() to x+10 by 1;
output;
flag='';
end;
proc sql noprint;
select x into : test1 from &syslast ...
1
vote
3answers
222 views
SAS: Selecting frequency of multi-column value
I have this problem, but in SAS. To use the example provided in this question, I have 5 columns of names (name_1, name_2, etc.), and want to output a list in which the names are listed in descending ...
0
votes
1answer
558 views
INTERNAL ERROR :Failed assertion [PGE code :90105]
While trying to compile sample code with the Pro*C compiler I am getting:
c:\oracle\product\11.2.0\dbhome_1\BIN>proc iname=C:\Users\Selvaganapathy\Desktop
\pro-c\code\sample.pc
Pro*C/C++: Release ...
0
votes
1answer
109 views
Is there any company that is still using Pro*C SQL?
There is a semester where each student need to develop a system using VB.NET. As time goes by, its become easy to just copy and paste others project and edit the interface, images, etc. So my ...
2
votes
2answers
183 views
Why didn't SAS use my index?
I have a large SAS dataset sorted by field 'A'. I'd like to do a query that references fields 'A' and 'B'. To speed up performance I created an index on 'B'. This results in an unhelpful message:
...
0
votes
2answers
121 views
Subqueries yielding more results then expected on join of two subsets
I'm receiving more ID's then possible after performing a left outer join statement on two tables.
Context: I've narrowed down two tables from larger data sets. Below are the queries found I've used ...
0
votes
1answer
108 views
Generated C code (from Pro*C) contains absolute path
I am auditing C code that has been generated from Pro*C ages ago, and I have found this:
static const struct sqlcxp sqlfpn =
{
33,
"d:¥¥VS¥¥Projects¥¥SOMEDIR¥¥somefile.pc"
};
Absolute paths ...
0
votes
2answers
220 views
Migrating Pro*COBOL and Pro*C to Java: Is JDBC the way to go?
I am migrating Pro*COBOL and Pro*C (code with embedded SQL) to Java.
Am I right that I should move migrate all of the embedded SQL to JDBC calls?
Or is there a sort of "Pro*Java" way that Oracle ...
0
votes
1answer
200 views
Is this Pro*C pattern a kind of best practice, or even documented?
I have some legacy Pro*C code using the kind of constructs below.
This kind of pattern is found on online forums but nothing in the Oracle documentation.
In particular, Google can't find any doc about ...
2
votes
2answers
319 views
Pro*C passing array of parameters
I am trying to write Pro*C/C/C++ code to handle a query like this:
SELECT col1, col2, col3, col4 FROM table WHERE param IN(<set of values>);
I can have a C struct to retrieve the result and ...
