cancel
Showing results for 
Search instead for 
Did you mean: 

problem reading data from appln server

Former Member
0 Kudos

My requirement is to read data from appln server and batchinput the data to the fields.

Problem is the file in appln server has no particular structure. and it is a text file.for ex


KLART	OBJEK	CLASS	STATU	STDCL	XLINE	OBTAB	LKENZ	ATNAM	ATWRT
002	000000000000032047	W	1		1			REPA_KOSTEN_ANTEIL	                          1,9
002	000000000000032047	W	1		1			REPA_KOSTEN_ANTEIL_DATUM	13.06.2005

And also i need data only for fileds objek,REPA_KOSTEN_ANTEIL and REPA_KOSTEN_ANTEIL_DATUM

and if possible please provide me some code.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Looks like the output file is tab seperated.

All you have to do is create a structure similar to the output file structure.

After a read on the dataset u can do a split based on the delimeter tab.

After the values are assigned to the corresponding fields u can read whichever fields are necessary from this structure.

Please let us know if there are anymore things to be considered.

Sharath.

Former Member
0 Kudos
Former Member
0 Kudos

Thanks alot for your replies.

Iam working on it.

I hope i will get the result.

regards,

chandu.

Former Member
0 Kudos

Hi Sai,

There is a way to say thanks in SDN, reward points for the replies which helped u to solve the problem. Reward and close the thread once ur problem get solved.

Regards,

Judith.

Former Member
0 Kudos

Hi,

You can use "read dataset" statement to read the file from the application server. Do have a specific delimiter ? It seems to be "tab". If this the case you can split the workarea by "tab".

data separator(1) type x value '09'.

split WA at separator into f1 f2 .. fn.

Svetlin

Message was edited by: Svetlin Rusev