Solved_errors Index Page 5
In this solution we are going to review how to add a column to an existing table on SQL Server with default values. In this small solution you will learn how to add a columns in table. You can use the ALTER TABLE statement in SQL Server. We will show an example using the NOT NULL constraint.
If you are missing GeoPackages or ESRI FileGDB as suuported drivers, execute: pip install -I fiona --no-binary fiona. This will compile the source of Fiona and link to your installed libraries. Check here for full description of the problem.
When you install pip with "conda install pip" and you got the error "CondaOSError: OS error: failed to link", try to delete the pip package from your anaconda. See here for full details on how to solve this issue.
Use docker stop $(docker ps -a -q) to stop all containers. If oyu want to remove them jsut use "rm" instead of "stop". Check here to understand how the command works.
Detailed explanation on how to use bash loop using "for". See here some example how to iterate using bash.
If using AIX unzip throws the error End-of-central-directory signature not found. Check here for solutions
Solution to SAP GUI Login error: SAP System Message N. If someone changed the SAN volume name you will need to restart the system. Check here for more details. Sometimes restating the SAPMMC solves the issue.
Check here how to retrieve column names on Oracle database: Select column_name from user_ta.....
If you have an ABAP runtime error DBIF_RSQL_INVALID_REQUEST on your SAP system, check here the solution. For windows you will need the loopback adapter and in linux you will need to verify the /etc/hosts file.
When using a DB2 on AIX and trying to stop the DB2 instance the error "the database manager was not stopped because databases = are still active" was raised. To solved this issue use "db2stop force" or check other solutions here.