| Title: | DATATRIEVE INTEREST GROUP |
| Notice: | ADD KEYWORDS TO NOTES FOR EASY SEARCHES |
| Moderator: | IMTDEV::KRATZER |
| Created: | Fri Mar 21 1986 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 3011 |
| Total number of notes: | 9337 |
I'm trying to create a DTR record for the data below, but can't get the
data types to match. Following is a sample of the data I'm trying to
convert:
DTL
SUBLDGR ACCT ACCT CUR CURR BEG BEG
CODE NO NO DEBIT CREDIT DEBIT CREDIT
222 8008 001 000000000000{ 000000750000{ 000000000000{ 000000000000{
2MR 2040 001 000000000000{ 000006324667A 000000000000{ 000000000000{
2MR 2045 001 000000000000{ 000000300206H 000000000000{ 000000000000{
2MR 2050 001 000000000000{ 000000023955{ 000000000000{ 000000000000{
2MR 2240 001 000004831905E 000000011055E 000000000000{ 000000000000{
When I try to use FN$HEX_TO_DEC("FIELD"), datatrieve thinks I am trying to
define a label and gives an input conversion error. It also appears that
I need to strip off the leading zeros from the hex numbers to convert them
properly.
The data is stored in an RDB database running on VMS V6.2 and DTR V7.1. I
can probably accomplish what I need in SQL with a CAST, but prefere the
report writer in DTR for output.
Also, does anyone have a data type conversion chart showing the
representations for DTR from the various languages/data types (cobol, etc)?
Any assistance is appreciated.
Thanks,
Earl
223-3254
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 2988.1 | Fields look packed to me. | EVMS::PIRULO::LEDERMAN | B. Z. Lederman | Wed Feb 12 1997 18:10 | 22 |
| <<< Note 2988.0 by BUMP::ESTUDIVAN >>>
| -< Need Help Converting COBOL HEX to DTR Readable >-
|
| DTL
|SUBLDGR ACCT ACCT CUR CURR BEG BEG
| CODE NO NO DEBIT CREDIT DEBIT CREDIT
|
| 222 8008 001 000000000000{ 000000750000{ 000000000000{ 000000000000{
| 2MR 2040 001 000000000000{ 000006324667A 000000000000{ 000000000000{
| When I try to use FN$HEX_TO_DEC("FIELD"), datatrieve thinks I am trying to
I see a couple of problems.
First, by FN$HEX_TO_DEC("FIELD") I hope you mean something like
FN$HEX_TO_DEC(CUR_DEBIT), using the name of a real field.
But the input fields you show here are not hexadecimal. From the way
they look, they appear to be packed, with a trailing sign. This is a
valid data type within Datatrieve. Try defining the debit and credit
fields that way and see if things get better.
| |||||
| 2988.2 | AWASH::ESTUDIVAN | Mon Feb 17 1997 16:46 | 6 | ||
Yes, I was using to HEXTODEC(Field), I have a synonym defined for the current month's debit (lazy). Thanks, will give it a try. Earl | |||||