. Almost made me want to get back into Pro-IV...almost 
.
- ProIV Resource Centre
- → Viewing Profile: Posts: Jeff Hon
Click the link below to see the new game I'm developing!
Community Stats
- Group Members
- Active Posts 29
- Profile Views 5,682
- Member Title Member
- Age 50 years old
- Birthday October 10, 1973
-
Gender
Male
-
Location
Melbourne, Australia
Previous Fields
-
First Name
Jeff
-
Surname
Hon
-
Nationality
Australian
-
Year Started ProIV
1993
-
Highest ProIV Version Used
5.5
-
Company Working For
IOOF Investment Management Ltd
-
Companies Worked For
AXA Australia
SunGard Asia Pacific
MDIS (now Northgate)
All Solutions Pty Ltd
0
Neutral
User Tools
Friends
Jeff Hon hasn't added any friends yet.
Latest Visitors
Posts I've Made
In Topic: Can we help?
11 December 2007 - 09:41 PM
I thought that pretty girl was part of the new save Pro-IV campaign . Almost made me want to get back into Pro-IV...almost .
. Almost made me want to get back into Pro-IV...almost .
In Topic: ProIV-Superlayer
06 July 2007 - 12:54 AM
For a start, you guys could try going to the Pro-IV website and downloading the available documentation there. URL below.
http://www.proiv.com...cumentation.xsp
http://www.proiv.com...cumentation.xsp
In Topic: Oracle Synonyms
26 June 2007 - 12:54 AM
Hi Joe,
Just out of interest, what error is your Pro-IV function returning to you when you try to access the Oracle synonym?
Jeff.
Just out of interest, what error is your Pro-IV function returning to you when you try to access the Oracle synonym?
Jeff.
In Topic: Oracle Synonyms
22 June 2007 - 07:01 AM
That's a good idea coz I'm going to the pub now anyway!
In Topic: Oracle Synonyms
22 June 2007 - 06:52 AM
The GRANT SELECT was a shot in the dark. Sorry...
We use synonyms here. Here's an example of the SQL of a synonym for a view belonging to another schema in a separate tablespace:
-- Create the new synonym
create synonym V_MEMBERS for <oracle_user>.V_MEMBERS@<database_link>;
The Pro-IV file def looks like this:
22/06/07 FILE DEFINITION DEV/JPH/PTS_98
CO- AUTO EXTERNAL FILE KEY RECORD
DIV SEQUENCED RECORD FORMAT TYPE LENGTH LENGTH
FILE NAME: V_MEMBER Y ORA 34 85
ALTERNATE: V_MEMBERS RECORD CODE: MSG:
DESC: File definition for V_MEMBERS ODS view
Delete
-------------------------- R E C O R D L A Y O U T -------------------------
DATA MAX FILL SPECIAL ARRAY
SEQ TYPE VARIABLE NAME LEN CODE DISPLAY-CODE CHECK SIZE
--- ---- -------------------------------- --- ---- ------------ -------- -----
001 AK V_MEMBER_DATABASE_NAME 3
002 AK V_MEMBER_EMPLOYER_ACCOUNT_ID 14
003 AK V_MEMBER_EMPLOYEE_DATABASE_NAME 3
004 AK V_MEMBER_EMPLOYEE_ACCOUNT_ID 14
005 A V_MEMBER_MEMBERSHIP_CATEGORY 40
006 A V_MEMBER_EMPLOYER_ACCESS_AUTH 1
007 N V_MEMBER_EMPLOYMENT_CEASE_DATE 10 DATE4 DATE4
I wrote a dummy Pro-IV update function to just select records from this Pro-IV file def and display in the ARNE in a UMSG and got the results as expected.
Not sure what else you need to do Joe. Any other members know something that I have left out?
Jeff.
We use synonyms here. Here's an example of the SQL of a synonym for a view belonging to another schema in a separate tablespace:
-- Create the new synonym
create synonym V_MEMBERS for <oracle_user>.V_MEMBERS@<database_link>;
The Pro-IV file def looks like this:
22/06/07 FILE DEFINITION DEV/JPH/PTS_98
CO- AUTO EXTERNAL FILE KEY RECORD
DIV SEQUENCED RECORD FORMAT TYPE LENGTH LENGTH
FILE NAME: V_MEMBER Y ORA 34 85
ALTERNATE: V_MEMBERS RECORD CODE: MSG:
DESC: File definition for V_MEMBERS ODS view
Delete
-------------------------- R E C O R D L A Y O U T -------------------------
DATA MAX FILL SPECIAL ARRAY
SEQ TYPE VARIABLE NAME LEN CODE DISPLAY-CODE CHECK SIZE
--- ---- -------------------------------- --- ---- ------------ -------- -----
001 AK V_MEMBER_DATABASE_NAME 3
002 AK V_MEMBER_EMPLOYER_ACCOUNT_ID 14
003 AK V_MEMBER_EMPLOYEE_DATABASE_NAME 3
004 AK V_MEMBER_EMPLOYEE_ACCOUNT_ID 14
005 A V_MEMBER_MEMBERSHIP_CATEGORY 40
006 A V_MEMBER_EMPLOYER_ACCESS_AUTH 1
007 N V_MEMBER_EMPLOYMENT_CEASE_DATE 10 DATE4 DATE4
I wrote a dummy Pro-IV update function to just select records from this Pro-IV file def and display in the ARNE in a UMSG and got the results as expected.
Not sure what else you need to do Joe. Any other members know something that I have left out?
Jeff.
Click the link below to see the new game I'm developing!
- ProIV Resource Centre
- → Viewing Profile: Posts: Jeff Hon
- Privacy Policy
