ca.portal.admin

Changing binary zeroes to comp-3 on database record

Discussion created by ca.portal.admin on Feb 10, 2005
For reasons I have not yet been able to ascertain, we have database
records with binary zeroes in an element defined as s9(11) comp-3. The
element was added several months ago using restructure and was
initialized correctly at that time. Records stored since then have
binary zero while older records have packed zeroes. I suspect the
records were added using a batch program and an old subschema (without
this element in the record) so the element wasn't initialized correctly
before the store. I will be quizzing the developer for more details
tomorrow. Meanwhile, I am hopeful that this esteemed body can offer
suggestions for changing the value from binary to packed.

Any ideas?

Thanks,

Roger C. Lawrence
Database Administrator
Seminole Electric Cooperative, Inc.
Tampa, Fl.
813.739.1518
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Changing binary zeroes to comp-3 on database record
"For reasons I have not yet been able to ascertain, we have database
records with binary zeroes in an element defined as s9(11) comp-3. The
element was added several months ago using restructure and was
initialized correctly at that time. Records stored since then have
binary zero while older records have packed zeroes. I suspect the
records were added using a batch program and an old subschema (without
this element in the record) so the element wasn't initialized correctly
before the store. I will be quizzing the developer for more details
tomorrow. Meanwhile, I am hopeful that this esteemed body can offer
suggestions for changing the value from binary to packed.

Any ideas?

Thanks,

Roger C. Lawrence
Database Administrator
Seminole Electric Cooperative, Inc.
Tampa, Fl.
813.739.1518
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Connections Articles -- last try
"It seems that some folks got garbage instead of a real message in my last
submissions. I apologize for that and am sending the message again. For
those that received the message, please forgive the duplication.

Bob Wiklund

Hello to all.

The IUA Board has decided to make the issues of Connections more
focused on technical issues and to this end, we are working to build an
issue on
the topic:

Application Integration & the Web

With suggested article subjects:

* Integration Design
* TCP/IP
* MQ Series
* ODBC/JDBC
* EDI
* XML
* Working with Oracle
* Future Directions
* “Webifying”
* “GUI-fication”

However these are just suggestions and any related topic will be
gratefully received. If you wish to contribute something, please tell us
when you
think you could have it - unless of course you feel you have
something to hand that would meet the need, in which case please just send
it. All
articles will be attributed or not as you request.

We would hope to be able to construct the issue by the end of
February.

Best regards,

Brock Shaw
IUA Connections Editor
brock_shaw@bcs.org.uk
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Fw: Connections
"Count the City of Tampa contingent in too...

Mark Casagrande
Lead Systems Analyst
City of Tampa, Florida
Strategic Planning and Technology Department
Information Technology Services
Phone: (813) 274-8484
Email: Mark.Casagrande@tampagov.net
KAY.ROZEBOOM@IOWA.GOV 2/8/2005 10:09:42 AM >>>
Me too.

Outcomes