Jump to content


- - - - -

File Definition


3 replies to this topic

#1 Guest_Brandon_*

Guest_Brandon_*
  • Guests

Posted 07 December 2005 - 12:42 PM

Hello,

The following is an Oracle Table Definition (defined by a Client so I take no responsibility for it's design).

CREATE TABLE EXAMPLE
(
KEYONE VARCHAR2(6 BYTE) DEFAULT ' ' NOT NULL,
KEYTWO VARCHAR2(12 BYTE) DEFAULT ' ' NOT NULL,
UPDATED_DT DATE DEFAULT sysdate,
UPDATED_BY VARCHAR2(12 BYTE) DEFAULT ' ',
REQUIRED VARCHAR2(4 BYTE) DEFAULT ' ' NOT NULL,
GENERAL VARCHAR2(8 BYTE) DEFAULT ' '
)

Never the less I need to add to this table, UPDATED_DT is causing a write error (when it is removed, adding to the file doesn't fail).

The File Definition for this field is;
NUMERIC N (5), EXTERNAL TYPE =DATE, EXERNAL FORMAT = BLANK

Any help would be appreciated, even if it is directing me to the appropirate documentation.

Cheers,
Brandon

#2 CSuarezdelReal

CSuarezdelReal

    Advanced

  • Members
  • PipPipPip
  • 91 posts
  • Gender:Male

Posted 07 December 2005 - 02:27 PM

Hi!

What's the error text you're receiving?
Claudio Suárez del Real
"It is not the strongest of the species that survive, nor the most intelligent, but the ones most responsive to change."

#3 Mike Schoen

Mike Schoen

    Expert

  • Members
  • PipPipPipPip
  • 198 posts
  • Gender:Male
  • Location:Guelph, Canada

Posted 07 December 2005 - 02:34 PM

We set NLS_DATE_FORMAT=yyyymmddhh24miss
at the environment level before running our application.
Also, we found that you need to set null permitted to 'Y' in the pro-iv file definition.

#4 Chris Pepper

Chris Pepper

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 369 posts
  • Gender:Male
  • Location:United Kingdom

Posted 07 December 2005 - 05:19 PM

If the table is only being added to, and the Oracle default for this field is the system date is there any reason it needs to be in the ProIV definition at all?



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users