List of Contributions

SangGyu Jeong

Infrasoft

Contact Details

Infrasoft

My Content

1 to 20 of 50+ total
Posted By SangGyu Jeong Jan 26, 2021 8:50 PM
Found In Egroup: Informix
\ view thread
Unfortunately, the customer is currently using version 9.4, and there seems to be no plans to upgrade.😭​ Presumably, they were investigating their software. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jan 26, 2021 7:56 AM
Found In Egroup: Informix
\ view thread
​ Thanks for the reply. This is a question I got from a customer. I guess the customer checks the version in the ifxjdbc.jar file and believes that there is a class that can also check the version in ifxjdbcx.jar :) ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, ...
Posted By SangGyu Jeong Jan 26, 2021 5:24 AM
Found In Egroup: Informix
\ view thread
Thank you for your reply. I couldn't check the version of the ifxjdbcx.jar file with the command in that document. It seems that the version information does not exist in the ifxjdbcx.jar file.​​ ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------ ...
Posted By SangGyu Jeong Jan 25, 2021 11:48 PM
Found In Egroup: Informix
\ view thread
Hello All, Version information of the ifxjdbc.jar file can be checked with the com.informix.jdbc.Version class. I want to know if the version information of the ifxjdbcx.jar file exists. When the ifxjdbcx.jar file is uncompressed with the jar command, the Version class cannot be found, so the version ...
Posted By SangGyu Jeong Jan 14, 2021 6:48 PM
Found In Egroup: Informix
\ view thread
@Andreas Legner Is it a hidden feature? There are still many unknown worlds.. ;) ​​ ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jan 14, 2021 7:50 AM
Found In Egroup: Informix
\ view thread
@Art Kagel Oh, I have one more question. Can I use the bit shift operator (>>, <<) function in Informix? ​ Should I make my own function..? ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jan 14, 2021 7:21 AM
Found In Egroup: Informix
\ view thread
​ I am always surprised by your knowledge. Thank you for the detailed explanation. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jan 14, 2021 2:33 AM
Found In Egroup: Informix
\ view thread
Thanks for the reply. The sample query was also a good reference. ​​ ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jan 13, 2021 10:21 PM
Found In Egroup: Informix
\ view thread
Hello All, Is there a catalog table to find the precision and scale values ​​of decimal type? syscolumns has only collength values. Thanks, ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jan 9, 2021 9:10 AM
Found In Egroup: Informix
\ view thread
I remember that the proxy type was not specified in the connection manager configuration file, but I will check it again. Thanks for the advice. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jan 8, 2021 2:02 AM
Found In Egroup: Informix
\ view thread
Hi All, Query execution performance is different when connecting to the db server through the connection manager and when connecting directly to the db server. Is there any reason or defect? It's hard to see as a network problem. Previously, connection manager 3.50.FC7 and informix server were 11.50.FC7, ...
Posted By SangGyu Jeong Jan 6, 2021 1:40 AM
Found In Egroup: Informix
\ view thread
Hello All, I want to know the usage of sbspace by table. In the case of BLOBspace, it is possible to check the usage for each table with the oncheck -pe command. ---- checking utilization for table using BLOBspace $ dbschema -d testdb -t mycatalog ... create table "informix".mycatalog ( catalog_num serial ...
Posted By SangGyu Jeong Jan 5, 2021 8:42 PM
Found In Egroup: Informix
\ view thread
Thanks for the advice!​ ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jan 5, 2021 8:49 AM
Found In Egroup: Informix
\ view thread
Wow, it's amazing that there is a way to check like this. Thank you.​ ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jan 5, 2021 12:09 AM
Found In Egroup: Informix
\ view thread
Hello Community, Below is the process I tested after receiving questions from customers about how to find the functional index. Is this the right way? ---- test step $ dbaccess stores_demo - Database selected. > CREATE TABLE circles ( radius FLOAT ); Table created. > CREATE FUNCTION circleArea( ...
Posted By SangGyu Jeong Dec 23, 2020 2:21 AM
Found In Egroup: Informix
\ view thread
Hello Amit, It is difficult to determine exactly what value to use for BUFFERS. Consider the factors that will increase the virtual segment area (lock, session memory, sort memory, etc.) and set it within the physical memory size excluding the memory used by processes other than oninit. In my case, ...
Posted By SangGyu Jeong Dec 23, 2020 1:38 AM
Found In Egroup: Informix
\ view thread
I also installed 14.10.fc5 to see this change. It is nice to be able to leave a timestamp without a command like date in the onstat result. :) https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.adref.doc/ids_adr_0495.htm ------------------------------ SangGyu Jeong Software Engineer ...
Posted By SangGyu Jeong Dec 21, 2020 5:08 PM
Found In Egroup: Informix
\ view thread
Hello Paul, Should I request a special build of version 12.10.xc14 to use the DBINFO_DBSPACE_RETURN_NULL_FOR_INVALID_PARTNUM environment variable? Setting environment variables doesn't seem to make any difference in behavior. # export DBINFO_DBSPACE_RETURN_NULL_FOR_INVALID_PARTNUM=1 # echo "select ...
Posted By SangGyu Jeong Dec 16, 2020 1:26 AM
Found In Egroup: Informix
\ view thread
I also got version 14.10.FC5 from the Software Access Catalog two days ago. :) ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Oct 30, 2020 10:17 PM
Found In Egroup: Informix
\ view thread
Thanks for your reply, Paul. I ran tar/untar as the root user and checked the permissions of each file. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------