Posted on Leave a comment

stored procedures

This post is how the database born in small business, today is impossible managed  big data whit simple SQL Basic , this information and database is  the year 2007

SQL is common find  stores procedures

for check  proc i find this query

A small database (<10 GB) is possible work whit SQLEXPRES, this is a database

A backup database

Whit a POS installer , only modify the SYSDBINFO, and creatre a login for user psa.

Another project to practice in MySQL is

Is a Online Store , this connection if in PHP and try to practice how to show item description and price


Posted on Leave a comment

IBM iSeries a.k.a AS/400

In today,s complex bussiness enviroment  the proprietary AS/400-iSeries “IBMi” system is a solution for manage customers in companies , i use Client Access  ,  Commands in the Control Language (CL) are promptable using the keyboard F4 function key. The most useful are


  • WRKSPLF – Work with spooled files
  • WRKQRY- Work with Queries
  • CPYF, CRTF, DSPF, CHGF, DLTF – Copy, create, display, change, and delete file


About payments is possible insert the information and generate a file  whit the amount, if the client in debt or is up to date, in my case a use for generate invoice payment,, all infformation  is a unique database

Support for 5250 display operations is provided via display files, an interface between workstations, keyboards and displays, and interactive applications, as opposed to batch processing with little or no user interaction

the configuration of 5250( terminal) configuration



Tables in AS/400