Search Results

Thanks For the response..I found out that the encoding character set used is ISO8859-1 and does not have the Trademark sign. The Trademark character is a reserved word and there displayed as SUB.
...

Hello All,

I am trying to extract a trademark character (™) from a varchar column in a DB2 Table. The result is to be placed in a sequential file in an AIX environment.

After the Extraction is...

need some advice on the following situation.





I have a DB2 table which has a varchar Column. This varchar column can have special characters like ©, ®, ™ .


When I extract from this...

Hello I need to run an sql script and then the output result to be in non-delimitted file

What is the execution command to obtain this.


For eg: the following outputs the result to a space...

Hi

Thanks for the suggestion but It doesnt seem to retrieve the value of the variable correctly in 2

(1)
DB_ID=`sh -c "echo DB_${MART}_USER"`

Result = DB_XMM_USER
(2)
DB_ID=`sh -c "echo...

Hi
The following command gives me error :The specified substitution is not valid for this command

export DB_ID=${DB_${MART}_USER}

What is the correct syntax for the above ?

Hi porter...

It works fine....is there a way where I can FTP without having to do anything on the .netrc file...In my case there was no .netrc file in my home directory so I created it.

thanks

Hi,

There is no ./netrc file to be found in my home folder.

Is there any other way to automate the FTP...

Thanks
Cosec

Hi !
I created a similar script as shown below to automate an FTP transfer and encountered errors. Appreciate any advice to resolve this issue.


The script:

#!/usr/bin/ksh
ftp 'IP ADD' <<...

thanks !!! it works the way i want it to now...

Yes That's possible but I prefer to find out if i can use an or statement

I need to check if $1 is A or B
I tried the following but it seems its not correct..would appreciate a suggestion ?


case "$1"
in
"A" || "B" )
;;
esac

Thanks