Problem solve Get help with specific problems with your technologies, process and projects.

How can I convert numeric AS/400 data to text in a Notes doc?

I am currently trying to replicate a data set from an AS/400 (ODBC) to a Notes database. Four of the elements in the AS/400 data are numeric but need to be text in the Notes documents. I cannot find any clear documentation on how to transform the numeric AS/400 data to text on the Notes documents. Help!
Check your DB/400 SQL manual for a method that converts data to text on-the-fly within a select statement. I have a number of jobs that convert numeric datatypes to text by including the SQL statement directly in the field mapping list on the RDBMS side. If your savvy with Notes development, you'll go a long way with this technique. Let me know how you make out.

Dig Deeper on Lotus Notes Domino Interoperability

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...