Thursday, September 18, 2014

Accessing Data on Microsoft SQL Server From IBM i

My latest challenge is how to marry data on our Ecommerce SQL servers with our IBMi DB2 data from IBMi system using SQL. We managed to setup a linked server on Ecommerce side of the fence which allows us to access data from both systems at same time, very cool.

I would love to be able to do this from the IBMi and I found this IBMi tech document. Accessing Data on Microsoft SQL Server From IBM i

I am looking for someone who may have used this software and give me some insight on how well it has worked or not worked. Does anyone have any experience with this software?

I requested a quote from our IBM business partner and first response was software does not run on IBMi. I am having the business partner re-query IBM since that is not what tech document is leading me to believe. Maybe the tech doc is flawed.

My hope is this capability would allow me to write SQLRPGLE programs on IBMi that can insert or update tables directly on the SQL servers. I would be bringing in EDI data into IBMi and updating tracking information on SQL servers that feed information to our E-commerce customers. VERY, VERY COOL! 


It's the only job I can think of where I get to be both an engineer and an artist. There's an incredible, rigorous, technical element to it, which I like because you have to do very precise thinking. On the other hand, it has a wildly creative side where the boundaries of imagination are the only real limitation. ~Andy Hertzfeld, about programming

Saturday, July 26, 2014

IBM i transfer Convert UNICODE to CHAR

For the past couple of years I have noticed when transferring a file to IBM i from Excel the default field type is UNICODE. That caused issues with data after transfer so I have been manually changing them during file transfer definition process to CHARACTER.

The spreadsheets had few fields so not much of a pain and I did not look for a reason why this is happening. I am now working with a spreadsheet that has 38 columns to be transferred and changing from UNICODE to CHARACTER has become a pain.

Fifteen minutes of Google search and problem solved. With Google the answers are always only a few keystrokes away!

Microsoft Excel Data Transfer Add-Ins: Convert UNICODE to CHAR

The command did return something about failed but it did just what was needed. Not sure what the failed message is for.

When the world says, "Give up,"
Hope whispers, "Try it one more time."
~Author Unknown

Have your best day!


Tuesday, May 20, 2014

Whoohoo!! Factory released KitKat 4.4.2 is installed and rooted!!!!!

Finally after many months of waiting and not really knowing if Samsung would update my beloved Galaxy Note 8” 3G GT-N5100 phone. 

Now I'm rocking 4.4.2, yeah baby!!

A simple process I followed at International Business Times ran smooth. I had a number of apps that did not update and received many failed to load messages when I restarted. All were fixed by uninstalling and reloading from play store.  All except Amazon Kindle, of course I am deep into a book I would like to finish. I have not found a fix as of yet but will chase it down this evening.

Also ran root as well from here

Thursday, February 20, 2014

EDI Invoicing

Another tough day ahead with EDI Invoicing. When the going gets tough the tough get going. We will overcome!

Monday, January 13, 2014

Welcome Aboard!

Today most excellent RPGLE programmer and good friend Rick Santiago starts as Senior Programmer/Analyst at Capitol Lighting.

Rick and I first met at GE Aircraft Engines back in 1996. Since then I have sub-contracted Rick to do my "heavy lifting" RPGLE programming at every job I have worked at. Every single one was a huge success.

At Pylon Manufacturing we created awesome "Pick to Pallet" process and modified BPCS order ingestion program to incorporate Extol EDI to automate inbound processing.

At Quipp Systems we created Payroll time tracking and really wild commissions program utilizing MAPICS.

At NanjingUSA Rick assisted in several projects which included implementation of S2K ERP and automated EDI process.

The next five years are going to be really exciting. We now work together at Capitol Lighting and sky is the limit. Capitol is dedicated to the IBMi and is looking to us to help integrate technology into operations as Capitol grows to 100 million dollar sales mark. This is a terrific challenge and opportunity for us and Capitol Lighting.

We are IBMi, watch us grow!


Tuesday, August 6, 2013

We're not in Kansas anymore....

Web Services, SOA, SOAP, HTTP, C++, WSDL, DISCO, Lions, Tigers and Bears. I’m used to diving into the deep end of the pool but after two days I think I have fallen into the Marianas Trench still waiting to hit bottom.

My current challenge is to send Name, Order and Email for new orders to LISTRAK Email Marketing Services utilizing API and SOAP formatted XML from our IBMi.

A little lite reading.....


If we are facing in the right direction, all we have to do is keep on walking.  ~Buddhist Saying

Monday, May 27, 2013

Whooohooo! IBMi V7R1 installed and working with no problems.

Good to be back and up to date, was at V5R4 and I was missing some of the enhancements that were in V6R1. I upgraded several machines three years ago to V6R1 and did not like going back and working with V5R4.

Since I am now essentially a one man IT shop (software/IBMi) and buried deep in fixing and supporting a failed ERP implementation I outsourced the upgrade to Source Data Products. Over the years I have done about 15 installs/upgrades but has never been my focus and it takes planning to do it right. I did not have the time to plan and do the upgrade myself.

Bob and Mark did a fantastic job. Bob from the standpoint of providing a price that could not be beat and Mark for performing a flawless upgrade. As a bonus he configured ASMI port. Now I have full remote control access to the IBMi. From a powered off status I can start machine without manual intervention at the CO-LO and see status of machine before IPL.

Total time for upgrade excluding software downloads and third party software upgrades was around 7 hours. One small bump with credit card processing software, they missed sending be the bulletin to change JAVA path. IBM changed the JAVA path to QOPNSYS which is where it should have been in the first place.

For under $3k Source Data Products cannot be beat. Now I have to quickly get up to speed with RDi Development Tools and V7R1 enhancements. Can't wait to utilize RUNSQL in CLLE, SDA and RLU in RDi.