topic Insert data from SAS VIYA CAS table to DB2 table in SAS Viya

Insert data from SAS VIYA CAS table to DB2 table

smm662002 — Fri, 24 Oct 2025 15:00:11 GMT

Hello,

I am using SAS VIYA LTS 2025.03.

I have a number of large tables in CAS and I need to insert the content into DB2 tables. The tables can not be moved from CAS to SPRE because some of the columns are quite large and will get truncated (these large columns correcpond to BLOB and CLOB Db2 data types)

Has anyone accomplished this before?

Thank you,

Smm662002

Re: Insert data from SAS VIYA CAS table to DB2 table

SASKiwi — Fri, 24 Oct 2025 21:27:24 GMT

According to this SAS doc it is possible using PROC CASUTIL.

Re: Insert data from SAS VIYA CAS table to DB2 table

smm662002 — Mon, 27 Oct 2025 09:23:39 GMT

Hello,

Thank you for your answer. Based on the documentation it seems to be possible. I have tried to use proc casutil, but I couldn't create a DB2 table but only a CAS table in a DB2 CASLIB.

What do you think it might be the right casutil syntax for the scenario: source VIYA CAS table and target DB2 table?

Thank you,

smm662002

Re: Insert data from SAS VIYA CAS table to DB2 table

Sajid01 — Wed, 29 Oct 2025 00:26:11 GMT

Hello @smm662002
Let the DBA's create the table and try uploading. Make sure you have all the required permissions.

Re: Insert data from SAS VIYA CAS table to DB2 table

SASKiwi — Wed, 29 Oct 2025 01:56:56 GMT

Google gives me this answer which I suggest you try (I don't have Viya to try):

caslib mydbreflib desc='My Relational Database CASLIB'
        dataSource=(srctype='<database_type>', /* e.g., 'oracle', 'postgres', 'teradata' */
                    server='<database_server_address>',
                    username='<database_username>',
                    password='<database_password>',
                    database='<database_name>');

    proc casutil;
        save casdata="<cas_table_name>" /* Name of the CAS table to save */
             outcaslib=mydbreflib /* CASLIB connected to your relational database */
             casout="<target_table_name>" /* Name for the table in the relational database */
             replace; /* Optional: Overwrites the target table if it exists */
    quit;