DSXchange

Hi , In one of existing datastage job ,for one coulmn say subfunction they have taken the value as char(176) which in the table holds the values of ascii characters after loading. Plesae see the below query : INSERT INTO T17020_TXN_CODE_DIM ( TXN_CODE_KEY, TXN_CODE, TXN_SUB_FUNCTION, TXN_CODE_FULL, ...

Hi ,

Can we ger row count in hash file.can i know how can we do that?

Hi I have my datastage server on windows environment and i need to get file from unix server which is remote. I need to execute the shell script in datastage job using execsh where datastage server is in windows environment. is there any alternative for this to run the unix commands which are in tha...

sorry for that

Hi

Jul07 is the most recent and aug07 file does not exist bec it will be generated on sept first.

Hi I have my datastage server on windows environment and i need to get file from unix server which is remote. I need to execute the shell script in datastage job using execsh where datastage server is in windows environment. Is it possible to this. or is there any alternative for this to run the uni...

Hi

Can i know what sed and its parameters will do.

i have a bit knowledge about unix.

find . -name '*.gz' -print | sed 's/^\(.*\)[.]gz$/gunzip < "&" > "\1"/' | sh

Hi Chulett, Thanks for your reply. I need one input from you for the find command: find . -name '*.gz' -print | sed 's/^\(.*\)[.]gz$/gunzip < "&" > "\1"/' | sh This will decompress all the zip files what it finds. but My requirement is i need to decompress the previous months...

Hi ArndW,

Can you also please suggest me how do i get previous month name using using date command .

Usualy date command give current date and time.

Hi arnw, Still i am getting same error. In the above post i am giving the command ls -rt1 | tail -1which will givesthe output Jul07.gz which is a zip file. the same .gz file i am paasing to gunzip command using | in unix box. i am unable to understand why am i getting this error even i am passing th...

Hi I am getting the following error while i am trying to send the oputput of one command to another. The command is : ls-rt1|tail -1| gunzip here ls -rt1 |tail -1 is avle to give the out put with all .GZ files i.e total 74105 -rw-r--r-- 1 testapp netx 7337398 Oct 09 2006 Sep06.09Oct06_11:58.gz -rw-r...

can you please give me any sample routine which works for this

any one help on this please

Hi I have the folder path like this in unxi server: /home/users/ftptci This path is having the files like May2007.gz,June2007.gz,Jul2007.gz as well other files say 58.gz ,xxxx.gz . Out of these files which are different names along with monthly file names as mentioned above. I need to capture the la...

can i have the syntax of the same