topic Re: Copy Table data in NonStop Servers

Copy Table data

Saurabh_PB — Thu, 17 Apr 2025 11:28:11 GMT

We want to copy table data in Tandem from one system to another. Table structure present another system, so we just want to copy the data. Can anyone please suggest commands for this activity? Either using sqlmp or fup utility.

Thanks in advance.

Re: Copy Table data

Mr_Techie — Thu, 17 Apr 2025 14:29:14 GMT

@Saurabh_PB

You can use SQLMP or FUP depending on your environment.

For speed, reliability, and simplicity: use FUP COPY. It's optimized for Tandem.

Re: Copy Table data

Saurabh_PB — Mon, 21 Apr 2025 11:07:30 GMT

Thanks for your reply. But in our case, I want to copy the data between two environment. So I am looking for below options (if possible) :-

1) Generate insert queries from source

2) Generate data in csv format , which can be uploaded/inserted into target.

Please let me know , if any of these options available.

Thanks in advance.

Re: Copy Table data

Mr_Techie — Fri, 25 Apr 2025 07:00:37 GMT

@Saurabh_PB

To copy data between two Tandem (HPE NonStop) environments where the table structure already exists on the target, you have two main options:

Option 1.

Generate INSERT Statements
Use SQLCI to select data and format it as SQL insert statements:

SELECT 'INSERT INTO target_table VALUES (' || COL1 || ',' || '''' || COL2 || '''' || ');' FROM source_table;

You can spool the output to a file and run it on the target system.

Option 2.

Export to CSV Format

You can simulate CSV output in SQLCI:

SET SEPARATOR ','; SELECT * FROM <schema>.<table>;

Spool the output to a file (data.csv), transfer it, and then use a custom loader or script to insert into the target.

NOTE: Note: Tandem does not have a native CSV import utility — inserting from CSV requires a custom loader, script, or small program.

Query: Copy Table data

support_s — Mon, 28 Apr 2025 07:18:07 GMT

Hello,

Let us know if you were able to resolve the issue.

If you are satisfied with the answers then kindly click the "Accept As Solution" button for the most helpful response so that it is beneficial to all community members.

Please click on "Thumbs Up/Kudo" icon to give a "Kudo".