DSXchange

Check if you have the same file format and the line terminators in both of them. In both files i am using delimiter as comma. But the parallel job sequential file has option of final delimiter =end but there is no option is server job sequential file of "final delimiter" Help is appreciat...

In both files i am using delimiter as comma.

But the parallel job sequential file has option of final delimiter =end
but there is no option is server job sequential file of "final delimiter"

Help is appreciated.

Hi, 1) I am created a sequential file using folder stage. The source to folder stage is a single file. The output from folder stage is filename, record. The data is loaded successfully in the target sequential file in this server job. When i am trying to read this server job generated sequential fil...

Hi, 1) I am created a sequential file using folder stage. The source to folder stage is a single file. The output from folder stage is filename, record. The data is loaded successfully in the target sequential file in this server job. When i am trying to read this server job generated sequential fil...

Hi, I am trying to read a file using folder stage. The problem is the file name has space in it. The folder stage reads file whose name i specify in "WildCard" field except the file that has space in its name I tried using single and double quotes like "filename" or 'filename'. B...

Hi, I am trying to read data from XMETA of DataStage.The XMETA table/view has VARGRAPHIC as data type. As DataStage does not have VARGRAPHIC as the datatype, i used NChar and other datatypes in db2 connector stage, i am getting the following error: ERROR during execution of DB2-CLI requests: SQL_ERR...

Hi We have a datastage job which reads from a table and loads in to target table using 2 odbc stages. Diagram --------Transformer-----ODBC ODBC ----------processing ------Transformer-------ODBC NOTE: Both the target ODBCs load the same table. We are implementing Slowly changing Dimension 1. To imple...

All users are not able to login to datastage, including dsadm. Previously it used to work. We didn't change anything to retrace.

The webconsole is not opening, I mean the page itself is not displaying. But the WAP Server is running fine.

I am able to ping to the server now, still the issue exists.

All WAS, ASBAgent, Datastage are all running.

Appreciate experts advise on the above questions.

The .odbc.ini file is read first, to determine which ODBC driver to load into memory. It is the ODBC driver for Oracle that needs to consult tnsnames.ora. All the connection details like Hostname, Alternateservers, portnumber that is available in tnsnames.ora is available in odbc.ini. Then why does...

So, odbc stage uses both odbc.ini and tnsnames.ora files.
If yes, could you please explain, which is read first and order of execution, and how to implement load balancing using odbc.ini

Hi, Currently we are using ODBC stages to connect to our oracle source and oracle target database. My understanding is ODBC stages will use odbc.ini and will not use tnsnames.ora I would like to use the load balancing the way it is used in tnsnames.ora Can i do load balancing using odbc.ini file ?? ...

I am not able to ping to the ip address.

Went through the /etc/hosts and found the hostname in the second field [after the ip address].
The link is not opening.

Is everything, including the metadata repository database, installed on the same system? When you attach to http://hydhtc100643d:9080 do you get a login screen? This is an old post, but since issues I am facing is exactly same and since this is unresolved trailed. I am hijacking this thread :) I tr...