DSXchange

hi, thanks for your response. yes that's the only thing i can think of also and i dont think the permissions are there.

thanks

hi i am trying to view a text file in server version8. i am trying to view the file in a sequential stage. the path is defined as follows: D:\MajTest\mtest.txt however when i view the file the following messgae is displayed: DSBrowser..Sequential_File_0.DSLink2: DSD.SEQOpen Failed to open mtest.txt ...

Thank you, it seems to have done the trick

Thanks for all your points, appreciate it. i will give that a go and let you know how i get on.

thanks again

sorry i forgot to mention the Status field isnt in a table, it is generated within my job to obtain the single character values as described.

hi, i currently have two fields in my table (prodid, status) if the Status is 'A' for a Prodid then i need to set all Statuses for that ProdId to 'A' else leavealone. Example below: ProdId: Status: 1 A 1 I 1 B 2 I 3 I The results i require as: ProdId: Status 1 A 1 A 1 A 2 I 3 I Just cant seem to cha...

thanks for all the suggestions guys. appreciate it.

hi

yes it is specified as a nullable column for the Date SQL Type and nullable for Varchar which returns all the rows.

thanks

the column in question is a date filed. when i specify the column type as a VarChar it shows all the rows. however when i specify the column type as a Date SQL type, it only shows non-null rows for the file.

Hi, I am trying to view all the rows in my sequential file. however if a column contains a null value the row is not shown when i view the file. my particular file has around 30% nulls in a certain column and as result all the data is not being shown when i view. any suggestions as to how to correct...

Why not just include it in your file metadata in the Sequential stage and then promptly ignore it? :wink: Add another column at the end. Scroll over to the right and set the Missing Column attribute to one of the ones that doesn't say 'Error' or 'Warn' - like 'Replace'. Then it won't matter if it i...

Hi all, I have an issue with a set of files which I am concatenating to form one full file for processing. The issue is that at the end of every record on one of the input files there exists the following character ^@ (null character). This has resulted in that I have got the "too many fields i...

Thanks guys for your advice, I achieved this through the ugly way

Hi, I have a question which I hope someone will be able to help me with. I have a series of records which consist of payments over a given period (11). Therfore there are 11 fields, some will be populated with 0 (i.e. no purchase) and other columns would be populated with a value eg 10.00(showing a ...

Thanks guys, I have tried both and they have done exactly what was needed