Re: XDP 4.0 and Informix 5.03
I suspect that XDP is little used. Is XDP an o/s or is a machine?
I think I remember coming across some Honeywell-Bull machines with
XDP in the name, but that would have been a few years ago now...
TIME is part of I4GL and not part of SQL as understood by the engine.
You should be using CURRENT HOUR TO SECOND in place of it.
INSERT INTO ImageData (x, timechanged, y)
VALUES (szX, CURRENT HOUR TO SECOND, szY)
This applies to any platform, not just XDP.
Yours,
Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>
}From: aamodt@login.eunet.no (Geir Aamodt)
}Date: 6 Jul 1995 18:48:52 +0200
}X-Informix-List-Id: <news.15192>
}
}I have been scanning this conference for a while now,
}and I haven't seen anyone mentioning the combination of
}XDP and Informix yet.
}
}Is it because XDP is seldom used or what?
}
}I am trying to use the TIME statement directly in a SQL INSERT sentence,
}but I get the 4GL error -4373 (grammatical error) when I am doing it.
}
}The sentence is:
}INSERT INTO ImageData (x,timechanged,y) VALUES (szX, TIME, szY)
}
}The timechanged variable is a "datetime Hour to Second"
}
}[...]