Greetings,
I have solved this dilemma.
Looking back on some stuff Neil Armstrong sent me in the past did the trick.
I defined the date-in as 1,8,display, and then I EXT DATE=DATE-IN.
Same works with the dollar amount.
Ernie
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of Newton, Ernie
Sent: Tuesday, 15 March 2011 8:50 AM
To: [log in to unmask]
Subject: [HP3000-L] Suprtool question
Greetings,
I am trying to read a file and extract data from that file to put into an Image dataset. I take the data from the file and define fields to match what the database requires. Everything is working except a dollar amount and a date.
The date in the file starts at byte 43 and looks like this...20101022 The date in the dataset is define as J2 I define the date in the input file as DATE,43,4,DOUBLE which creates an item defined as I2, (that's eye-2), in my self-describing file. According to my manual, I2 and J2 data items are identical.
The problem is that when I extract 20101022 and put it into my self-describing file, it turns into 842019120
A similar thing is happening with my dollar field.
The dollar amount in the file starts at byte 194 and looks like this...123456789012 ( I put a big number in there to test) I dollar amount in the dataset is defined as P12.
I define the dollar amount in the input file as DOLLAR,147,6,PACKED When I extract 123456789012 and put it into my self-describing file, it turns into 31323334353
What am I doing wrong?
We are using Suprtool, version 5.0.
Thanks,
Ernie
________________________________
This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
CAUTION: This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify RYCO Hydraulics Pty. Ltd. immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of RYCO Hydraulics Pty. Ltd.
________________________________
This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
