The little tool ls for “list” shows the contents of your working directory.
But ls has some lesser-known cousins that can list out far more than files.
Here are a few Linux commands that I’ve found especially useful for quickly
seeing key information about your system.
| Command |
Description |
lsblk |
Lists block devices like drives and partitions. |
lspci |
Lists PCI devices such as network cards and GPUs. |
lsusb |
Lists connected USB devices. |
lsof |
Lists open files and the processes using them. |
When using Sage 100 with the ProvideX database ODBC scalar functions can be useful in our SQL statements for date conversions, data check, and data manipulation.
In the previous article found here: Sage 100 2013 ODBC Help I went over the basic function of using SQL commands with a Sage 100 system. In this article I will go over the advanced feature including joins. The first join I will show is what Sage calls the Cross Join:
In needing to write a small program for my company access data from our Sage 100 ERP I found documentation lacking concerning writing SQL commands for the Sage 100 ODBC driver. Here are are some commands that I found useful when writing SQL statements for Sage 100.