List of Contributions

Paul Watson

Oninit

Contact Details

My Content

1 to 20 of 50+ total
Posted By Paul Watson Mar 26, 2020 8:46 PM
Found In Egroup: Informix
\ view thread
You sure you have the Linux version ? Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit®️ is a registered trademark of Oninit LLC
Posted By Paul Watson Mar 26, 2020 4:00 PM
Found In Egroup: Informix
\ view thread
If you can take the outage then nothing wrong with approach. But using ontape –s | ssh newserver ontape –r is probably quicker Cheers Paul
Posted By Paul Watson Mar 26, 2020 11:52 AM
Found In Egroup: Informix
\ view thread
Cdr migrate server
Posted By Paul Watson Mar 26, 2020 11:51 AM
Found In Egroup: Informix
\ view thread
I am not saying it doesn't exist on platforms, just that is not installed and not allowed to be installed. OAT/InformixHQ are all great (enough), but if you are not allowed to install them then you are back to the "always there" tools, dbaccess and onstat etc
Posted By Paul Watson Mar 26, 2020 10:35 AM
Found In Egroup: Informix
\ view thread
Multiple versions of sed as well, the solaris one does't support the –i option – very annoying J
Posted By Paul Watson Mar 26, 2020 9:34 AM
Found In Egroup: Informix
\ view thread
The other con for Perl is it not always available at all customers, awk/sed etc always are there Cheers Paul
Posted By Paul Watson Mar 20, 2020 10:37 AM
Found In Egroup: Informix
\ view thread
you can always install another CSDK in a separate directory and statically compile, that should work along side the installed versions Cheers Paul > Hi Paul, > > Good idea. If Art doesn't see anything in the output I just sent, I may > try that PREPARE option. > > Thanks. > > ...
Posted By Paul Watson Mar 20, 2020 10:24 AM
Found In Egroup: Informix
\ view thread
Try a later CSDK ??? If that is not possible try changing to prepare/execute statement, that should let the engine prep the SQL and not the client layer Cheers Paul > I recently downloaded the utils2_ak package and was trying to build it, > but I hit an error. When compiling dbscript.ec, I got ...
Posted By Paul Watson Mar 20, 2020 8:20 AM
Found In Egroup: Informix
\ view thread
Functional index Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit®️ is a registered trademark of Oninit LLC
Posted By Paul Watson Mar 17, 2020 11:38 AM
Found In Egroup: Informix
\ view thread
Yep, really giving examples of why this format is useful Cheers Paul > You can also use the construct for more interesting and useful constants > like: > Current time: >> select current; > > (expression) > > 2020-03-17 11:27:25.983 > > 1 row(s) retrieved. > > Translating ...
Posted By Paul Watson Mar 17, 2020 11:30 AM
Found In Egroup: Informix
\ view thread
So this is (probably) the quickest way to get current time, which is useful select current; 2020-03-17 12:28:25.000 Cheers Paul > Typically this is used like the Oracle construct: > > select 7 from dual; > Or the Informix constructs: > > select 7 from sysmaster:sysdual; > select ...
Posted By Paul Watson Mar 15, 2020 7:50 PM
Found In Egroup: Informix
\ view thread
As Art suggested doing it in SPL and the use a derived table, or do it via a temp table > Thanks a lot SanGuy, > > This is new to me. I didn't know this existed. > > This gives me results really close to what I am looking for; however, I > want to improve it a little more: When the ...
Posted By Paul Watson Mar 14, 2020 1:58 PM
Found In Egroup: Informix
\ view thread
Did I miss something, happens often, but .... select datecol, count(*) from XX group 1 order 2 desc ???? Cheers Paul > ???Hi Everybody. > > I am looking for an aggregate function that implements the "mode" of a > list of dates. > The mode is the number (in my case a date) that occur the ...
Posted By Paul Watson Mar 14, 2020 1:55 PM
Found In Egroup: Informix
\ view thread
My testing with Java/12.10 showed that max'ing the buffer was not a good thing, the fun part was finding the sweet point for the system or just setting dynamically based on the anticipated query return size Cheers Paul > Hello Chanaka, > Increasing the fetch buffer size in the Informix ODBC configuration ...
Posted By Paul Watson Mar 12, 2020 1:23 PM
Found In Egroup: Informix
\ view thread
Running nfs ? Just tweak the nfsd Cheers Paul > The following message is written repeatedly in the /var/log/messages file > in the RHEL 7.5 (64 bit) system :- > "too many open connections, consider increasing the number of threads". > The above message is written to the /var/log/messages ...
Posted By Paul Watson Mar 12, 2020 9:02 AM
Found In Egroup: Informix
\ view thread
Gets my vote Cheers Luddite > With all of the header/footer and surrounding noise, this list utility has > a large footprint. I'm typing perhaps 120 characters? Watch that come > across as a 64KB message. Let's go back to usenet. > > j. > >
Posted By Paul Watson Mar 11, 2020 7:36 AM
Found In Egroup: Informix
\ view thread
Surely everyone would want this ? I use the old ETX blades to index my copies Cheers Paul > SangGyu, > > Art's proposition about the Advanced Data Tools training is at the moment > the best you can have. IBM has not done any effort during last years on > updating the training material, ...
Posted By Paul Watson Mar 10, 2020 9:01 AM
Found In Egroup: Informix
\ view thread
There are a few companies that deliver training for you, non of us would had over our courses for free :-) You could develop your own but probably not a cost effective solution unless you are intending to deliver multiple courses Cheers Paul > Hi All, > I would like to provide Informix technical ...
Posted By Paul Watson Mar 9, 2020 3:20 PM
Found In Egroup: Informix
\ view thread
changing data structures is (probably) the key. Try again but on a very busy system you might still get it. Try hanging the engine and grabbing an onstat -o AFAIK a hung system shouldn't see these, but in prod ........ > Hi Folks. > > This looks like corruption in the internal tcb structures: ...
Posted By Paul Watson Mar 6, 2020 7:36 AM
Found In Egroup: Informix
\ view thread
True, just depends on how much you like to type Cheers Paul > Looking for a way to change a bit easier ... In Oracle, the TO_NUMBER > function provides the ability to convert from hexadecimal to decimal. > > SQL> select to_number('401f6d', 'xxxxxxx') from dual; > > TO_NUMBER('401F6D','XXXXXXX') ...