Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations GregLocock on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data types in a universal file definition for sql queries

Status
Not open for further replies.

tallpaul

Computer
Dec 21, 2000
1
I'm trying to set a data dictionary using a proprietary technology to give a relational view of a hierarcical legacy database. The records on the database will have certain signed numeric fields that are longer than sixteen characters, the SQL manual suggests I declare them as 'COMP' so that they only take up eight bytes of physical storeage but this returns some pretty dodgy results. Am I doing something obviously wrong ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor