topic Re: SQL wrapper script question in Operating System - HP-UX

SQL wrapper script question

Allanm — Fri, 12 Jun 2009 18:00:47 GMT

I created a sql wrapper script which is doing a select statement on a set of data in a for loop.

The problem is that the select statement returns a truncated view(specially member name) of the output, can this be un-truncated.

Please find the script attached.

Thanks,
Allan

Re: SQL wrapper script question

Patrick Wallek — Fri, 12 Jun 2009 18:49:56 GMT

Can you post a piece of what is returned?

Perhaps you need to set some formats for the columns in your select.

Re: SQL wrapper script question

Allanm — Fri, 12 Jun 2009 18:53:12 GMT

I would like to rephrase this again... the problem lies not with the sql part but with the for loop itself.

The file from which the for loop is picking up entries has spaces and its picking up entries based on the spaces and not carriage return as I would like.

Is there a solution to this problem.

BTW the enties are like this -

Allan M
...

so it taking Allan as one entry and M as another entry and I would rather want the value of $j to be Allan M and not just Allan or M individually.

Thanks,
Allan

Re: SQL wrapper script question

Patrick Wallek — Fri, 12 Jun 2009 19:01:37 GMT

Ahh...I see.

Try this instead:

#!/bin/bash
while read j
do
(~allanm/bin/sql passwd <select member_id,member_name from ContactInfo_tbl where member_name = '${j}';
EOF
)
done < ~allanm/data

Re: SQL wrapper script question

Allanm — Fri, 12 Jun 2009 19:03:31 GMT

That worked!

Thanks,
Allan