Copy multiple files into one DB2 file

How do you copy multiple stream files into one DB2 file using wildcard (*) at the cpyfrmstmf command?

 
CPYFRMSTMF FROMSTMF('/usr/sap/bgt/edilink/snd/orde/orde*+  
             TOMBR('/qsys.lib/sap.lib/edibgt.file/edibgt+
             .mbr') MBROPT(*REPLACE)

You can't - CPYFRMSTMF does not allow patterns (wildcard characters) to be specified. If you're trying to take multiple stream files to one database file you have to issue the command multiple times, using MBROPT(*ADD).

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this Search400.com Featured Topic: Database issues resolved

Dig Deeper on DB2 UDB (universal databases)

Using full-text search for symbols in SQL Server When querying exact SQL phrases that include symbols, you need to add your own logic with SQL Server's full-text search feature, as it does not index non-letters. Options include incorporating a WHERE clause with LIKE to contain your symbol and also using a CASE in the SELECT list to rank the symbol and non-symbol results. In this tip, SQL Server expert Michelle Gutzait shares steps to successfully search for exact phrases that contain symbols.

Retrieve SQL (RTVSQL) source statement Search400.com member Jean-Paul Lamontre discusses the SQL Visual Explain tool, which comes with iSeries Navigator. Jean-Paul finds this tool very handy to improve the performance of SQL statements. In this tip he shares why he feels it would be beneficial for you to also have Data Description Language (DDL) in the index, and he explains the best way to achieve that.

Import a text file to a DB2 table One user writes, "I need to "import" a text file located in the user computer to a DB2 table in the database, what's the best way to do this?" DB2 expert Kent Milligan offers some advice.

Copy text to SRCMBR If you have a CL program in a text file on your PC, you can send this text to SCRMBR of QCLSRC and have the program ready.

Easy code copying ... without CODE400 Copy any Web source code in an iSeries source file in five steps.

Copying a stream file to a physical file

Related Q&A from Kent Milligan

SQL server error message -321

To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... Continue Reading

Choose which column names are returned via ODBC when working with DB2 files

When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ... Continue Reading

Developing tables in a parent-child relationship in DB2

When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to ... Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our AS/400 experts

View all AS/400 questions and answers

Copy multiple files into one DB2 file

Dig Deeper on DB2 UDB (universal databases)

Related Q&A from Kent Milligan

SQL server error message -321

Choose which column names are returned via ODBC when working with DB2 files

Developing tables in a parent-child relationship in DB2

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Refresh your data center cooling lexicon

Comparing Linux distributions: Red Hat vs. Ubuntu

Get eco-friendly with LEED data center certification

Dig Deeper on DB2 UDB (universal databases)

Related Q&A from Kent Milligan

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.