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 https://en.wikipedia.org/wiki/Stored_procedure

http://docs.openlinksw.com/virtuoso/ch-sqlprocedures/

for check  proc i find this query

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

A backup database

https://www.dropbox.com/preview/Public%20(1)/SCPV170520101632.bak?role=personal

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

https://www.dropbox.com/preview/Public%20(1)/INSTALADOR%20SISTEMA%20TIENDA.zip?role=personal

Another project to practice in MySQL is http://blog.xcero.xyz/site/

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