DSXchange

Mark Griffin AMP Sr. Application Developer Data Warehouse Systems CIGNA Healthcare Two College Park Drive, 454 Hooksett, NH 03106 Phone: 603-430-7610 603-268-7239 Fax: 603-268-7909 email: griffimk@hlthsrc.com >>> dmaharaj@netcare.co.za 08/07 7:41 AM >>> I have create on the datastage server a system...

I have create on the datastage server a system dns to connect to the sql sever which I have tested and it does work. The problem that I have , is that when I go into manager - tools , import , odbc table definitions - the server logs me in but does not display any tables or files. I have also tick t...

Mike: You need to have an association defined that groups the various multivalued fields together so that DataStage knows to normalize them as a set. Add an association name to field 7 of each of the dictionary records you want to group as a set (e.g., called PARTS), then create an association phras...

Tried calling it PARTS, but when I normalize on PARTS, then click View Data, I get the following error: Invalid association operation. Column or association name "PARTS" does not exist in dict file of FSR. Do I need to do something to the dict? -----Original Message----- From: Jerry P Bank...

Perhaps because your association name PART_NO is the same as your field name. Try a different association name. ----- Original Message ----- From: "Roosa, Mike" To: Sent: Friday, August 04, 2000 8:41 AM Subject: Universe multivalues to SQL > Okay, Ive followed the examples in the documenta...

Okay, Ive followed the examples in the documentation and cant get this to work right. I have the following dictionaries: PART_NO 1 = D 2 = 42 3 = 4 = PART_NO 5 = 15L 6 = M QTY 1 = D 2 = 43 3 = 4 = QTY 5 = 4R 6 = M When I import the universe table definition, I check the box about metadata supporting...

Mike, You dont have a DataStage problem, you have a definition problem. Basically it is your call. A date in SQL Server has a date and time component - you have to decide what you want to put in it. I would have suggested combining your call date and call time into a single SQL 7.0 field. It comes b...

Anyone else running a configuration the same as or close to this successfully? See below Dec Alpha, Datastage and informix Datawarehouse. RE: Datastage V3.6r2 (ODBC V3.11) on Compag ( Dec ) Alpha running TRU 64 Unix V5.0 (Rev.910), loading informix 9.21 (Also on Dec Alpha) > > Does anyone have exper...

HERE IS THE CODE THAT I USE TO CREATE A DATETIME STAMP Oconv(DATE(),"D-YMD[4,2,2]"):" ":Oconv(TIME(),"MTS") Mark Griffin AMP Sr. Application Developer Data Warehouse Systems CIGNA Healthcare Two College Park Drive, 454 Hooksett, NH 03106 Phone: 603-430-7610 603-268-7239...

Mike, I think your date is backwards it should be 2000-03-06 15:10:34 Try using the d-ymd[4,2,2] conversion instead of d4-. Mark -----Original Message----- From: Roosa, Mike [mailto:Mike.Roosa@getronics.com] Sent: Thursday, August 03, 2000 11:20 AM To: informix-datastage@oliver.com Subject: Timestam...

DEVCALLHISTORY.CTransformerStage1.DSLink4: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO pubs.guest.CALL_HISTORY (CallID, SiteID, CustomerDetailID, RepAssigned, CallStatus, CallType, CallPriority, CallDate) VALUES (?,?,?,?,?,?,?,?) SQLSTATE=22005, DBMS.CODE=0 [Ardent][SQL Client][O...

Mike, There is an existing DataStage function called TimeStampFull, which can be used to create a timestamp. I have included the code below. Hope this helps. Mark Transforms a timestamp or Date input depending on second argument: "TIMESTAMP" => produces a timestamp with time = 00:00:00 fro...

I should have it explained it a little better. I have a dict item called CALL_DATE which has an output conversion of D2/ and a dict item called CALL_TIME with an output conversion of MTS. The goal is to get CALL_DATE into a SQL 7.0 column called CallDate which is a timestamp type and CALL_TIME into ...

UniVerse SQL does not support the TimeStamp data type. Therefore DataStage can not use it. You have two possible routes, either create an I-descriptor to generate a timestamp, but declare it as Char(19) in the DataStage metadata, or import the date and time as separate columns then use a column deri...

How should my dictionary and column definitions be defined to properly insert universe date and time fields into a SQL timestamp field? I cant get it to work properly.

Thanks,
Mike Roosa