Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
script change column 22
Name: showpiecerodent Date: March 27, 2009 at 03:24:13 Pacific OS: Solaris Subcategory: General
Comment:
A recent change means that the sql being produced has too much text in column 22 for the target system which is limited to 30 characters. I need to know how to post process the sql file to truncate whatever is in field 22 to the 30 leftmost characters. The INSERT command is every third line. Thanks
Name: nails Date: March 27, 2009 at 09:34:11 Pacific
Reply:
Since your OS is Solaris, are you asking for a unix shell script to do the post processing? If so, this awk script grabs the first 30 characters of field 22, resets field 22 to these values and prints the record:
Name: showpiecerodent Date: March 27, 2009 at 10:18:40 Pacific
Reply:
Thanks nails. I'm not sure what to do about the other 2 lines. One does an insert in another database and the other is a comit command. Obviously I don't want to change these lines with the script. This requires some "if" and "where" presumably?
Summary: Hello Forgive my poor SQL knowledge. Im looking after an SQL 2005 machine which i inherited. I typically just need to maintain it, however, Im after getting a request to change something . I have a t...
Summary: Hi Lou: Hmm, in terms of DOS commands, I am tempted to say - yes, it can be done. But, I can't write a DOS script yet without doing more thinking. In general, the 'atomic' objects that DOS commands op...
Summary: Hi everyone, I have to run a conversion on multiple tables to change the data in one column on each table. I am happy to run this separately for each table, but I would like to know the best way to d...
0 
