You'll need the appropriate database driver (i.e. DBD:: module) installed to access any database. A quick CPAN search indicates that none exists for RainStor, though given that RainStor is apparently part of Teradata these days perhaps the Teradata driver will work. (Only one way to find out - have you tried?)

With the right driver in place, the basic procedure for connecting is the same, with the caveat that the syntax of the connect string itself - the dbi:Teradata:$DSN:1025 bit from your example - is driver-dependent. From the DBI documentation:

There is no standard for the text following the driver name. Each driver is free to use whatever syntax it wants. The only requirement the DBI makes is that all the information is supplied in a single string. You must consult the documentation for the drivers you are using for a description of the syntax they require.

Finally, tdat_lsn appears to be a Teradata-specific attribute, so you may have to read up on what it does and find an equivalent if you're looking to connect to a different type of database. The DBD::Teradata documentation (here, not on CPAN) has this to say:

tdat_lsn

Write-only connect() attribute, Read-only on connection handle.

When specified on connect():

• if specified with a value of zero, causes the session to allocate an LSN from the DBMS, which can be queried after successful connection using the tdat_lsn attribute.
• if specified with a non-zero value, causes the session to associate with the provided LSN value.

If not specified during connect(), no LSN action is performed, and querying tdat_lsn after connection will return undef.

After connect(), the LSN value can be queried via the database handle tdat_lsn attribute.

I reckon LSN may stand for "log sequence number", but you'll know better than I do.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.