DSXchange

Hi , i had faced a serious probelm today when i was working on designer, suddenly datastage started thrwoing some error messages 'Directory structure not found' when i checked project directory i found their was nothing except few file how can i solve this problem ,can we restore directory structure...

Thanks For all help
i am done with this process its working fine now i am able to calculate my number of tilde in my file & also able to do validation for file.

It was really a great help from dsxchange menbers.

Ok fine jest tell me how can i count occurence of each ~ in a file through datastage jobs rest i will try from my own.

if u say i have to use the routine

i have already treid commang grep -c '~' filename

but its not giving me satisfactory results

Hi , I need to create a shell script to perform a validation on a file, ihave a file which is ~ seperated.The File contents Looks like below: HEADER~NFOS-LOH~CIGMA~20051109~124430~ 63893 TRADE_ACTION~TRADE_TYPE~CONTRACT_ID~TRADE_DATE~LOCAL_PRODUCT_TIERA~LOCAL_PRODUCT_TIERB~LOCAL_PRODUCT_TIERC~PUBLIS...

try removing quote character by specifying 000 in seq file format at quote char txt box.
coz i tried same data but its working for me?
can u also tell us tht wats the delimiter of file?

its ok you mean i have to create a batch file & feep that at mt FTP server NT machine & i dont know then how to access that .bat file how i will run that to get last line of file coz again the problem would be how to run .bat file to get the result . Can u tell me how can i use rlogin or ftp...

is it possible any how if i can do it through shell script coz i am having option of that only in here.

Hi Kenneth Bland , Thanks for reply. you have exactly understood my problem actually in our previous release we did the same ie; taking the file to unix box then used a routine which were searching for string 'TRAILER' so if the string is present then only we process file. now as we know that size o...

Hi, I have an a scenario where i have to check for a string 'TRAILER' at FTP server Which is a NT server my datastage server is a unix server. i want to load a file from Nt FTP server only when i get that string in that file, so how can i check for the string as no command available at ftp to check ...

Try utilityrunjob utility to pass parameters.

Khan

I have seen some ftp that suppport umask for the target files. But most ftp implementations support some kind of local shell capability, so you can say something like this in your ftp script after the files have been recieved. .... get $filename .... ! chmod 111 $filename .... Check the documentati...

you can use command stage in server jobs See the exact problem of mine in the beginning :oops: i know i can use command stage for shell script my problem is that how can i change file permission if i archieve a file to some other folder i want to make it read only after successful transfer. can any...

Hi ketfos, Archieving i am doin just by Ftp>ftp stage so its just creating a similar copy to another folder then after completing this job i am deleting the file from original location by using shell script ,in that i am using delete command to delete the file [#!/bin/sh HOST=$1 USER=$2 PASSWD=$3 ft...

The same series of steps you would have to do if you were telnet'ing into the box after the ftp and changing the permissions yourself. But the problem here is when i try to telnet that server from command prompt its says Could not open a connection to host: Connect failed. Might be server was not c...

As long as the remote server allows it, there are the 'Telnet before' and 'Telnet after' commands available inside the FTP stage. Setup the 'after' session to log in and issue the chmod command. Hi craig can u tell me exactly wat should i specify in that option to change the permission or should i ...