Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Merge to Files

3 posts in General Discussion Last posting was on 2007-10-04 11:54:54.0Z
Brent Fenderson Posted on 2007-09-29 13:46:37.0Z
From: "Brent Fenderson" <bfenderson@mdisolutions.com>
Newsgroups: sybase.public.impact
Subject: Merge to Files
Lines: 7
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: 71-81-6-137.dhcp.spbg.sc.charter.com
X-Original-NNTP-Posting-Host: 71-81-6-137.dhcp.spbg.sc.charter.com
Message-ID: <46fe573d$1@forums-1-dub>
Date: 29 Sep 2007 06:46:37 -0700
X-Trace: forums-1-dub 1191073597 71.81.6.137 (29 Sep 2007 06:46:37 -0700)
X-Original-Trace: 29 Sep 2007 06:46:37 -0700, 71-81-6-137.dhcp.spbg.sc.charter.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.impact:2089
Article PK: 230170

I would like to combine two files into one output file. The files have a
unique employee number key in each. Has anyone done this?

Brent Fenderson
bfenderson@mdisolutions.com


Wietze Drost - iSOFT Netherlands Posted on 2007-10-03 13:37:51.0Z
Sender: 7fd8.46f2389a.1804289383@sybase.com
From: Wietze Drost - iSOFT Netherlands
Newsgroups: sybase.public.impact
Subject: Re: Merge to Files
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47039b2f.2f26.1681692777@sybase.com>
References: <46fe573d$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Oct 2007 06:37:51 -0700
X-Trace: forums-1-dub 1191418671 10.22.241.41 (3 Oct 2007 06:37:51 -0700)
X-Original-Trace: 3 Oct 2007 06:37:51 -0700, 10.22.241.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.impact:2090
Article PK: 230174


> I would like to combine two files into one output file.
> The files have a unique employee number key in each. Has
> anyone done this?
>
> Brent Fenderson
> bfenderson@mdisolutions.com
>
>

Hi Brent,

Wat you can do is send the data from both files to the sfm.
Write the content of the first file to a db file, using the
employee numberas key. When a second message arrie, check if
a db file exist with the same employee number. If so read
the content of the db file and combine to an outbound
message, sends that to an file based aim. (using submit) and
then delete the db file.
Probably there are other sollutions if you don't have to
change the data, but only combine the files.


Brent Fenderson Posted on 2007-10-04 11:54:54.0Z
From: "Brent Fenderson" <bfenderson@mdisolutions.com>
Newsgroups: sybase.public.impact
References: <46fe573d$1@forums-1-dub> <47039b2f.2f26.1681692777@sybase.com>
Subject: Re: Merge to Files
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: 72-254-160-174.client.stsn.net
X-Original-NNTP-Posting-Host: 72-254-160-174.client.stsn.net
Message-ID: <4704d48e$1@forums-1-dub>
Date: 4 Oct 2007 04:54:54 -0700
X-Trace: forums-1-dub 1191498894 72.254.160.174 (4 Oct 2007 04:54:54 -0700)
X-Original-Trace: 4 Oct 2007 04:54:54 -0700, 72-254-160-174.client.stsn.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.impact:2092
Article PK: 230175

Thats what i was thinking about but wanted to see if there was a solution
without using a db. Tks

<Wietze Drost - iSOFT Netherlands> wrote in message
news:47039b2f.2f26.1681692777@sybase.com...
>> I would like to combine two files into one output file.
>> The files have a unique employee number key in each. Has
>> anyone done this?
>>
>> Brent Fenderson
>> bfenderson@mdisolutions.com
>>
>>
> Hi Brent,
>
> Wat you can do is send the data from both files to the sfm.
> Write the content of the first file to a db file, using the
> employee numberas key. When a second message arrie, check if
> a db file exist with the same employee number. If so read
> the content of the db file and combine to an outbound
> message, sends that to an file based aim. (using submit) and
> then delete the db file.
> Probably there are other sollutions if you don't have to
> change the data, but only combine the files.