Question Mark Runyan · Jun 27, 2023 Full Db backup cbk file from Cache 2017.2.2 needs to be restored for SQL access We are retiring a hosted application for an electronic health care records (EHR) system which stored the data on Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2017.2.2 (Build 867_4_20245) Thu Oct 8 2020 16:58:40 EDT. The hosting company is providing me with a single CBK file. I need to install a database system to restore the database and provide occasional SQL access for reports when necessary. I'll need to maintain access to the data for an approximately 10 year retention period. Not sure how to approach restoring this old of a database and eventually upgrading it to a newer re #Backup #Data Import and Export #Caché 0 36 1 967
Question Mark Runyan · Jul 6, 2021 Cache numeric comparison via ODBC something is not working How strange this is to me. I'm querying a table against a numeric(15,2) column call max_client_resp_service. When I query max_client_resp_service > 0 or any number, I get results, but they are not always right, for example where max_client_resp_service > 5 returns values less than 5, e.g. #ODBC #SQL #Caché 0 6 0 273
Question Mark Runyan · May 5, 2021 STRING_SPLIT equivalent in Cache SQL I'm looking for a SQL function equivalent for SQL server STRING_SPLIT. I have records like this: join_to_tx_history (key), ss_note_multi_dict_1_value (varchar) 64559.001 Assistant Principal, Case Worker, Client, Dad, Daughter, Mentor, Mom, Other, Principal, Psychiatrist, School Counselor, Teacher and I like the field ss_note_multi_dict_1_value split to rows for each comma delimited value. So I can get this: #Caché 0 2 0 773
Question Mark Runyan · Apr 9, 2021 Measure all the row counts of every table in a Cache database Hi, in the end I want a report like this: #Databases #SQL #Caché 0 4 0 891
All posts
All posts
All posts