Recent content by tdgulbra

The parser is the same parser, you are just supplying 2 different parameters. From your examples, it looks like you have Queryman set up to not allow Teradata extensions ("WITH" is just such an extension). For the substring example, the ODBC driver behind Queryman is probably...

Cajun: With your insistance that workers can not be fully informed, the workers have to try to derive the reason for their work. When left to their own devices in this manner, they tend to develop "management conspiracy theories." In other words, management is out to get us. They treat...

***Did it ever occur to you that you get two different recommendations from two different members of the technical staff - neither of whom are aware of mandates coming down? *** If the subordinates don't understand the mandates coming down, it is because the manager has failed to adequately...

No. You can not alter the primary index of a Teradata table. The only option to change a primary index is to re-create the table. Tony

I had a similar problem. You need to download the XP version of NAV. They keep a record of your original payment and that will let you get the new version. There is an order number on your receipt that is needed to retrieve your payment record. Once I found mine, the procedure was very simple...

BJ - I hear ya'. I am also at the whim of my employer. I did not mean to suggest you could move. The current market does not support that idea. I was just trying to say that we can't get our idea of competence from those who are unfamiliar with our work. Again, I don't know your exact...

As a DBA, let me just chime in with a couple of thoughts. 1) The DBA is basically the guardian of the data. When he/she asks for justification for a certain security level, they are just trying to protect themselves. 2) As far as government contractors go, the "rank and file" of...

What type is column_d? The two "rogue" bytes sound like the length bytes for a varchar field/column. Perhaps it is a typo, but I noticed in the first Insert statement a comma missing between column_3 and column_4. I guess the other standard questions apply: Which database release...

True. I missed that line in the original post. Yours is the better solution, Patten.

Unless I am misunderstanding the problem, here is another possibility Select cast(TextString as Integer) (format'999999');

I agree Dieter, but I've always had problems with data mode and trying to read it with anything. If you .set TITLEDASHES off and use the title modifier as follows: sel blahblah (title''); and then export in record mode, the file is readable by anything, including MS applications. Just my...

Those messages don't appear in a: .export report file=filename By doing this, you can then use the multiload syntax: .run filename Tony

Try the following syntax: Begin logging on each select on user username; The results should be stored in dbc.accesslog Is there something I am missing about your request? Tony

Brian, No, the 9 is the TOTAL number of digits. Maybe this will help. The format statement for a Decimal(9,2) would look like this: format'9,999,999.99' There are 9 total digits, 7 before the decimal and 2 after. Does that make more sense? Tony

Ok Brian. For integer fields: There are 8 bits/byte, 4 bytes/integer so the largest number an integer can hold is (2**31)-1 or 2,147,483,647. That is what it would be if every bit were on. A character field to hold an integer would need to be 11 (or 12 for signed integer) characters long...