SQL in Multisource universe in IDT...problems.

[system]

@karmakoma

here the questions:
1)How is it possible that in IDT, I created a single source universe and the code pasted works, but the same code in multisource environment doesn’t work?
2) If I use SLQ-92 stabdard how can i replace function like “Date format”, “CAST”,“INTERVAL” etc?
3) If the mysql/maria db dialect is not accepted in IDT, how can I create the same conditions? FOr x. I need to create the first of the previous month, or the last day of the week etc…Is there any solution?

From my own experience - as soon as you choose multisource, your database-specific SQL goes out of the window. You can’t use oracle, sql server or anything that worked in a single-source. You’re stuck with SQL-92 code that (presumably) is the lowest common denominator that works with everything.

There are some SQL-92 multi-source IDT dates that work here (3rd post down): DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2 Have a play around with some of them and adapt for your needs.

Debbie

---

Debbie (BOB member since 2005-03-01)