DSXchange

thank you

I took the help from the below DSX post and it worked fine.But I didn't understand how to purge the existing logs from XMETA.
Can any one explain?

Again thanks a lot for this post.

viewtopic.php?t=125607&highlight=purge

I am using Datastage Version 8.1 and my director running very slow all of sudden but for couple of projects we set in project adminstartion to auto purge level to 5 days. What could be the reason to slow down the director, if it is due to the no of logs created, how we can purge the logs in Version ...

Here is my uvodbc.config file contents:

[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1

<testodbc>
DBMSTYPE = ODBC

Any thoughts?

I am using the ODBC Connection by creating a DSN entry and using that DNS entry for Importing the table definitions for Stored procedures.

YEs, I am able to connect to this RAC from UNIX box using SQLPLUS.

Criag, when i use the following entry it is failing with an error: TNS:listener could not resolve SID given in connect descriptor ODBC.ini file entry: [testodbc] Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMora23.so Description=DataDirect Oracle Wire Protocol driver ApplicationUsingTh...

I agree with you, i need a sample odbc.ini entry for Oracle RAC in this scenario.

I am trying to establish an ODBC connection for my ORACLE RAC database to import metadata using table definitions of stored procedure. Here is my tnsnames entry: test.world = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = test1) (PORT = 1521) ) (ADDRESS = (PROTOCOL = TCP) (HOST = test2) (PORT = ...

During the data load process using MLoad/Fastload/Fastexport utilities to teradata, is there a way to encrypt the data?

Please suggest.

Thanks

thank you everyone for the response, we have too many parsing rules and decided not to do with datastage.

thank for the reply.

so which stage do you recommend to read and parse HTML files?my HTML pages/files contains one question and four answers like an exam questions.I need to parse the question and answers and load into a SQL server database.

Thank you for the reply,You are right if no parsing it is working.but I need to parse the contents in HTML and then load into database.How can we parse it and load?

Hi,

Is there a way to read HTML files using Datastage and load into SQL Server datbase?

Any help greatly appreciated.