In many projects I have been requested at some stage to update all jobs to use the proper batch user, and in some particular cases the clients decided that they wanted the owner and creator of the job to be updated too. I have designed below queries to accomplish such task directly on TBTCO and TBTCP tables:

I had a question, which code page codes do we have on this system? And which one should we use for UTF-8? In this post I will get you through the answer, how to check this, and a example of how is this used.

I'll quickly show how to upload to an Abap instance using function modules. Useful when you have to upload files to a server without having access to the OS.

A client just called asking for some help to extend their Sybase database as they were running out of space on saptools database, I just took the opportunity to take screenshots and prepare some info that I will explaining on this post as a reference for this situations.

During a migration of one PO system we had to stop all PO channels when the App was still not installed because at the time of the App installed we wanted to be on the safe zone without any risk of channels getting started automatically.

When running SWPM (A.k.a sapinst) there are a bunch of parameters you could use to modify its behavior, on this post I'll be providing a list of all the parameters available (Up to the version of the SWPM used in my case) and the three I use the most.

Explanation of a major DB upgrade for Sybase from 15.7 to 16.0, screenshots included!