DSXchange

dsedi wrote:If the inputcolumn is Zero's then it's writing as +0000000.00 which is fine.

You sure thats ok. Zero is neither negative nor positive. Double check with your business if thats acceptable.

You need to do type conversions. If the file was created by a server job, everything is a string. For Date fields you need to specify StringToDate(). Handle nulls before that.

I havent worked with rcp but if you have to do perform any transformations, then you need to explicitly define those columns. Someone needs to confirm this.
If they are simple transformations like null checks and trimming you can utilize sed,awk for that. Search in google for more details.

Are you doing any type conversions for this particular column? Give us more info on your design.

Also as suggested earlier, do the DecimalToString() in a stage variable so that it gets executed once per row, instead of three times as per your code. What Sainath.Srinivasan was saying is if the number is less that 0, which is a negative number then pass it as it is else append the positive sign. ...

Welcome Aboard
Do the same thing in a sequence job. Use wait for file activity to see if a file is present and then branch your execution accordingly.

In order to get the value of an environment variable, use GetEnvironment(%envvar%) which is present under functions->Utility.

Read about dsjob command in developers guide under command line. Its basically run at the unix level. dsjob -report will give a report of the job that will contain the start time, end time, the elapsed time, job status etc.

If the dsjob command is the same for 8.0 as well then you should look at dsjob -report and get all the information from there. Go through the manuals, there should be more in-built reporting abilities of 8.0

Ray already did give you a much simpler solution.

You are right. It does not have any documentation on those two functions. O well, CurrentDate() gives the current date and CurrentTime() gives the current time. If you need more info on them, search the forums.

Run in sequential mode and filter out all records that are empty in the second column. This will leave you with all records that have data in the second column including two or more adjacent rows with Property in the first column. Pass it through the transformer see if you have adjacent rows with sa...

You can also write a small routine to intake all the columns and depending upon the number of duplicate records to be created, generate the rows and send it back.

Thats even more confusing now. Where is File B's data. Use 'code' tags to maintain formatting.

Yes, right. It works if its readonly and protected but not the other way around. To be really honest, thats odd. Are all the jobs containing that particular column giving you this kind of behaviour or just some jobs? I think you should get in touch with support.