Is there a way to pass an argument to an input file from a bash script? (ASE 12.5, 15.0, 15.3, 15.7)

[Former Member]

Dear Support Team,

I would like to pass an argument (or more) from a bash script to an input file so I can use that parameter in my SQL code.

cat sybase.sh

#!/bin/bash

isql -S SERVER_NAME -U USER_NAME -P PASSWORD -i input.sql

cat input.sql

USE master

GO

SELECT COUNT(*) FROM <argument_from_bash_script>

GO

Is this possible somehow?

Thanks in advance.

Regards,

Laszlo

[Former Member]

Thanks a lot Mark, it worked.