Toad World® Forums

Query giving wrong results when using Cross Connection Editor

Hi,

I am using cross connection Editor for my Project. I am using ODBC generic- Informatica.

While running a query in the SQL editor , my query works fine.But while running the same query in Cross Connection SQL editor(Pro Edition) , some columns mainly Date Columns and
the amount column is changing to “Null” and even the column names displayed also is changing.

(A) Output when running in Cross connection SQL editor(Pro Edition) - see the null values in Update_DT and Create_DT columns

(CURRENCY_NAME, UPDATE_DT, CREATE_DT, CURRENCY_CD) VALUES

(‘UGANDA SHILLINGS’, NULL, NULL, ‘UGX’),
(‘UKRAINE HRYVNIA’, NULL, NULL, ‘UAH’),
(‘UNITED STATES DOLLAR’, NULL, NULL, ‘USD’)

-> SQL Query Output when running in SQL editor : No Null Values and result is perfectly fine.

(CURRENCY_CD, CURRENCY_NAME, CREATE_DT, UPDATE_DT) VALUES

(‘USD’, ‘UNITED STATES DOLLAR’, ‘1/26/2004 10:05:01 PM’, ‘8/12/2013 10:49:54 PM’),
(’-1’, ‘UNKNOWN’, ‘1/26/2004 10:08:41 PM’, ‘1/26/2004 10:08:41 PM’),
(‘GBP’, ‘ENGLAND POUND’, ‘2/23/2007 1:21:25 AM’, ‘8/12/2013 10:49:54 PM’)

(B) See the column name sequence is changing:

In SQL editor - > Column name is in the sequence-> This is the correct sequence.
(CURRENCY_CD, CURRENCY_NAME, CREATE_DT, UPDATE_DT) VALUES

In Cross Connection SQL editor - > Column name sequence is different.
(CURRENCY_NAME, UPDATE_DT, CREATE_DT, CURRENCY_CD) VALUES

Please let me know if there is some issue with my settings or is this the bug?

Thanks,

Bharat Bhusan Singh

To investigate this we need some extra information. Please do the following:

  1. Turn on logging with this command-line parameter - /log=all

  2. Run your query in cross connection editor to produce wrong results.

  3. Generate a support bundle (Help > Support Bundle) and send it to me (igor.manokhin@quest.com).

  4. Send me also the query itself.

  5. We also need to know what are data types in Informatica of those fields returning null.

Thank you,

Igor.

(1)The query that that ran in cross connection editor to produce wrong results:

SELECT * FROM VT.VS_Leones.VT_CURRENCY_B;

here VT_CURRENCY_B is the table name.

(2) “CREATE_DT” AND “UPDATE_DT” column is displaying wrong results(i.e. null) and its Tdata types are TIMESTAMP.

also, other information i have sent to your Dell mail id.

Please let me know if these information are sufficient to debug the issues.

Thanks,

Bharat Bhusan Singh