RPG2SQL Integrator Tutorials & How To's

From Support

How To articles for RPG2SQL Integrator

C Creating a MS Excel Spreadsheet Template for use with RPG2SQL Integrator Creating an index on a MS Access Table via SQL using the RPG2SQL Integrator D Deleting Records from SQL Server Database using a DateTime field E Excel OLE DB Sample for RPG2SQL - writing to spreadsheet ExcelADO VB Sample for Inserting and Reading Excel Data ExcelRunScript RPG2SQL Function to run custom user VB script macros F Formatting Data/Time Criteria for an SQL Select statement G GCompiler Sample for using RPG2SQL Integrator with an ILE SQL RPG Program GExcel Sample to Merge Two Columns to a Third Column German Translation Tables for RPG2SQL Integrator H How to create an OLE/DB connection string

H cont. How to sort records using the ORDER BY statement in SQL M Microsoft KB Articles for using ADO and Excel N Number meanings for data types when using SQL GetDelimFlt Numeric fields are showing up as NULL when a spreadsheet is read with RPG2SQL O Odd data/Sample ILE RPG code to format ISO date/time field P Padding a character parameter when calling a program Progress Database ODBC User Guide R RPG Program Sample for Creating a New Spreadsheet Output File and populating the spreadsheet Reserving a new GUID in SQL Server S SELECT statement for Access database using Date for WHERE Criteria SQL UPDATE Sample for RPG2SQL Integrator SQL methods for reading records from a MS Excel Spreadsheet via ADO/ODBC

S cont. Sample Oracle Data Source String Sample Program to Create an Excel Spreadsheet using RPGSQL Integrator Sample Program to Read a Fixed Flat PC Text File using RPG2SQL Sample SQL User Defined Function UDF Sample empty spreadsheet template file for use with RPG2SQL Integrator Samples for coding SQL WHERE criteria in ILE RPG program when using RPG2SQL Integrator Selecting Records from SQL Server Database using a DateTime field Setting XLS colors in RPG2SQL T Testing to See if RPG2SQL Integrator PC Server Component is Running U Using RPG2SQL Source Samples with AS/400 System running a CCSID other than 037 (US) Using Text File Driver (ODBC) with RPG2SQL Using VBScript in XLS Command Notes

Articles relating to configuration problems, bugs, and other errors can be found in the Troubleshooting section.