Solved_errors Index Page 5
How to add a column to an existing table in SQL Server (ALTER TABLE Statement)
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.
Solved! Fiona 1.7.1 missing GeoPackage & FileGDB
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.
OSX: Python anaconda error when installing pip
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.
How to stop or remove all Docker containers with one command?
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.
Bash: How to use loops?
Detailed explanation on how to use bash loop using "for". See here some example how to iterate using bash.
How to Extract .zip File in AIX
If using AIX unzip throws the error End-of-central-directory signature not found. Check here for solutions
SAP GUI Logon Error Message: SAP System Message N
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.
Oracle: SQL query to Select Column Names From the Table
Check here how to retrieve column names on Oracle database: Select column_name from user_ta.....
Solution for ABAP Runtime Error: DBIF_RSQL_INVALID_REQUEST
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.
How to Stop DB2 Instance when the command "db2stop force" Fails?
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.
