DSXchange

hi
Can any one share your idea.how to do the above problem
thks
Sai

I have to write small ftp script . I have a target file in the below location and it has 2 columns . #outputDir#ETL_FINALIZED_PROPOSAL/EIM_EXTRACTED_PDF_list 1. LocalPath 2. LocalFileName I have to delete the files in the remote location with following parameters if LocalFileName = Remotefilename ft...

Hi
1.My idea is to store the processed files in hash file and comepare with input files and delete those matched records.

2. How can i delete the match files in remote location using ftp.
thks

Hi I have files in remote location. these files are inserted daily. after that i run the ETL job to process these files. I used ftp to get the files form remote location to datastage location. but i want to process only NEW files daily. IS THERE ANY FTP command which do . please share your thoughts ...

hi
Can you explain it more in detail where i have to modify the fttp script
thks

Hi
mput is there in my code before REmoteFIleName.
how can i mention to move all the files in local location to remote loation

`cd #LocalPath#ETL_FINALIZEDPROPOSAL/; echo 'user #UserName# #PasswordName#\n cd #RemotePath#\n mput #RemoteFileName#' | ftp -n #ServerName#`

thks

Hi I wrote a following script to move a file to a remote location.i want to move all the files like TD_ORD_SDAO* from local to remote location. but it is giving error SH: mput: not found. `cd #LocalPath#ETL_FINALIZEDPROPOSAL/; echo 'user #UserName# #PasswordName#\n cd #RemotePath#\n mput #RemoteFile...

HI
Thanks for your reply .
if i change the code to "In.YourString[2,40]" to remove first char of a string there is no phantom error.
thks

Hi I am geting phantom error in transformar stage .IMPROPER DATATYPE. 1.I went into project directory and found the below code in my job trim(Change(XYPGALTNBR, XYPGALTCHAR, " ")) my aim is to trim the first character from the string .so i store in stage variables. XYPGALTNBR - string XYPG...

HI I am getting following error. My job design just lookup to hash file and i use stage variable. where can i check the line number.In project directory how i have to search . thks DataStage Job 2983 Phantom 15548 Program "JOB.2107965739.DT.1415539559.TRANS1": Line 233, Improper data type....

Hi
I am using Folder stage to extract PDF files. and i set fully Qualified parameter as YEs .but i am getting following error.

: DSD_DIROpen Failed to set NLS map ISO8859-1 on directory

Can you share your idea.
thks

Hi
Thanks for your reply.
we have to parce data before using the pivot stage.
but how can we parce data based on delimitor ,.i dont know how many are there.

ex
key column txt
k1 k2 k3 k4 k5 abc,def,ghi.....


o/p

k1 k2 k3 k4 k5 abc
k1 k2 k3 k4 k5 def
k1 k2 k3 k4 k5 ghi

hi
can you guys explain little bit more clear with example.and also I have to delete original record.
pl share your thoughts
thks

Hi
my o/p is seq file. and i have to search for , in the string.if , is found
then each word will have to be inserted in new line.

ex
int.txt = abc , def,ghi

then
int.txt = abc
int.txt= def
int.txt= ghi

can you share your thoughts.
thks

hi I have seq input file and Lkup file in following way and total no of rows is around 10000 seq file lkup file 1 1 null null 2 2 3 3 null null 4 4 when i do match with not(notfound(lkupfile)) i am getting only rows which are not null . but i want to return all the rows. please share your thought sai