DSXchange

Thanks Sainath..

I got what i wanted.

Ereplace(Oconv(Date(),"DYMD[4,2,2]")," ", "-"):" ": Oconv(Time(), "MTS")

In that case, change the execute command where you read as cat <fileName> | tr -d '\n' ... Thanks Sainath & ArndW for your help. Achieved the required output. This is what exactly i wanted, bash-3.00$ cat /detld2/etl/CTI_London/SWP/delivery/e_OTCPrice_20090730_-1_RecordCount 0 bash-3.00$ cat /d...

Yes, I am aware that your UNIX and my UNIX differ, that is why I stated "on AIX". What UNIX are you on? The cut command is doing exactly what it should. When you output to a file UNIX added a <l ... My Unix is Solaris 10/SunOS 5.10. By the way, i couldn't get your completed message :( Is ...

Not sure what you want to achieve. Can you please rephrase your requirement. wc -m gives you number of characters and not words. So it gives you 2 - 1 for zero and 1 for newline. If ... That's true. I need to read only the "0/RowCount" from the file without the new line. Because,in the Ex...

On AIX the man pages read: head Command Purpose Displays the first few lines of a file. Syntax head [ -Count | -c Number | -n Number ] [ File ... ] If ... Hi ArndW, My man page contains, bash-3.00$ man head Reformatting page. Please Wait... done User Commands head(1) NAME head - display first few l...

You can do head -1 filename | cut -c1 ... Hi Sainath, The above code is also not working, bash-3.00$ cat /detld2/etl/CTI_London/SWP/delivery/e_OTCPrice_20090730_-1_RecordCount 0 bash-3.00$ wc -m /detld2/etl/CTI_London/SWP/delivery/e_OTCPrice_20090730_-1_RecordCount 2 /detld2/etl/CTI_London/SWP/deli...

What about "head -c 1 MyTextFile" to get just the first character of the file? You can use sed '$d' < MyFile > TempFile ; mv TempFile MyFile to remove the last line from a file. ... Hi ArndW, Even using sed also i could get the desired output. please correct if i typed something wrong, ba...

What about "head -c 1 MyTextFile" to get just the first character of the file? You can use sed '$d' < MyFile > TempFile ; mv TempFile MyFile to remove the last line from a file. ... Hi ArndW, I couldn't use "head" to get the first character of the file. bash-3.00$ head -c 1 /det...

Hi I am facing the problem while counting the rows & saving in a file. I am using Tail stage in parallel job to count the rows, i am exactly counting the rows & saving it in a file. (Format of the file :- Final Delimter string = end/none/null(tried) Delimiter = | Quote = none) My problem is ...

I dont have the access for UAT/PROD servers. I have access for only DEV servers.

Is it possible to export the UAT/PROD jobs?

Hi, I am new to datastage. Please help me to export a single job by command line argument. Please tell me the location/Procedure to use dsexport command I tried it and gets the below error. Please help me in this issue. bash-3.00$ pwd /detld2/etl/ascential/Ascential/DataStage bash-3.00$ dsexport /H=...

Hi friends,

I facing a problem in splitting the string by delimiter.
I need to take substring that should be in between 2 commas(",")

Please help me out