RE: Hex '00' to Hex '40'?

R
Hello Brad,

Can you explain this a bit more?  The web page (program) stores the received 
data in SQL Server 
on NT and DataMirror is used to propagate the SQL Server tables to the AS/400.  
Which fields 
are being translated incorrectly?  NULL fields are coming in as blanks? X'00' 
fields are coming 
in as blanks? NULL fields that happen to be initialised to X'00' by SQL Server 
are coming in as 
blanks?

Which version of DM are you using?  For a while they could not handle NULL 
fields except via 
SQL.  Do you have any exit programs running in DM to convert data or handle the 
updates (either 
%USER functions or option 15(?) from the file definition panel)?  Have value 
translations been 
defined for these files? 

A little more information is needed.  For instance, for a given record, what 
does it look like 
in SQL Server and what does it look like in DB2/400?

Personally, I think using a toy database is the root of the problem but then 
what would I know?

Regards,
Simon Coulter.

«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
«» FlyByNight Software         AS/400 Technical Specialists       «»
«» Eclipse the competition - run your business on an IBM AS/400.  «»
«»                                                                «»
«» Phone: +61 3 9419 0175      Mobile: +61 0411 091 400           «»
«» Fax:   +61 3 9419 0175      mailto: shc@flybynight.com.au      «»
«»                                                                «»
«» Windoze should not be open at Warp speed.                      «»
«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
//--- forwarded letter -------------------------------------------------------
> X-Mailer: Internet Mail Service (5.5.2448.0)
> Date: Tue, 29 Jun 99 13:12:16 -0500
> From: "Stone, Brad V (TC OASIS)" <bvstone@taylorcorp.com>
> To: "'MIDRANGE-L@midrange.com'" <MIDRANGE-L@midrange.com>
> Reply-To: MIDRANGE-L@midrange.com
> Subject: RE: Hex '00' to Hex '40'?

> 
> S wish it were this easy.  The fields are not nulls coming from the SQL
> server database when we are mirroring.. I dont know what they are.  The
> fields that they specify null in come across fine as x'40'.  The ones they
> don't come to us as hex'00'.
> 
> Here's why I don't want to do this in my program.
> 
> One the web page they made, you can select one of about 20 different item
> types.  For each item type, they set up a table (file).  For each file,
> there is one record for each order, including other type of information.  So
> a file looks like this.
> 
> Item number
> Price
> Text1
> Text2
> Text3...
> Text20
> ...
> 
> So, not only do I have to check 20 files, but I have to check 30 or so
> fields in each file.  That's a lot of checking.  
> 
> Again, when they do specify null as a value in their SQL database, things
> work fine.  When they leave it blank, it comes across as x'00'.  I didn't
> set up the datamirror stuff, but it looks like I'll have to try and figure
> out what is going on.
> 
> Thanks for all the suggestions.
> 
> Bradley V. Stone
> Taylor Corporation - OASIS Programmer/Analyst 
> bvstone@taylorcorp.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---