Post reply

what is initial catalog?

  • December 9, 2010 at 7:42 am

    #228318

    hello,

    when I am making a connection to DB2 in ssis I can see a option as Initial Catalog, can you guys can tell me what is this initial catalog?

    thanks

    Sasi.

  • December 9, 2010 at 8:05 am

    #1260576

    that's the database you want to connect to.

    The name "Initial Catalog" implies that you can switch to other databases after the connection, and your SQL commands could use use 3 part naming conventions like Otherdb.dbo.Tablename.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 9, 2010 at 9:18 am

    #1260620

    In SQL Server, if you don't provide this, you have a default database you are assigned to. Not sure how it works in DB2. In Excel, it can be the Worksheet.

    Lowell has the best explanation.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply