Jump to content


Jeff Hon

Member Since 26 Apr 2002
Offline Last Active Jun 11 2010 01:00 AM
-----

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 (w00t) . 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

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.

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.