Search:  
NamespacesDiscussions.NET v1.1Feedback
Trouble importing file
Messages   Related Types
This message was discovered on ASPFriends.com 'ngfx-sqlclient' list.


Greg
I have copied a shortened version of the text file I am trying to import
into my SQL Server database. I can't figure this file format out, can
anybody help me here?, I have no documentation on this file.

2002/05/15 02:29:30 20020514
BD800390000006B 00 FINSTRUCT SECURITIES (PTY) LTD
D 00000000 00000000
BD850390000006
BD860390000006
BD770390000006 00000000 0000000
0000000000000000OTH00019990929
BD780390000006N 00DM00
00000000000000000000000 C200 00000000
BD910390000006 000000000000000 000000000000000 000000000000000
000000000000000 000000000000000 000000000000000 000000000000000
BD800390000007B 00 CLSA GLOBAL EMERGING MARKETS.
D 00000000 00000000
BD850390000007
BD860390000007
BD770390000007 00000000 0000000
0000000000000000OTH00019991105 CLSA GLOBAL EMERGING
BD780390000007N 00DM00
00000000000000000000000 C200 00000000
BD910390000007 000000000000000 000000000000000 000000000000000
000000000000000 000000000000000 000000000000000 000000000000000
BD800390000008B 00 SG SECURITIES (JOHANNESBURG) (PTY)
LTD. D 00000000 E
00000000
BD850390000008
BD860390000008
BD770390000008 00000000 0000000
0000000000000000OTH00020000926
BD780390000008N 00DM00
00000000000000000000000NC200 00000000 SGSA
BD910390000008 000000000000000 000000000000000 000000000000000
000000000000000 000000000000000 000000000000000 000000000000000
BD800390000009B 00 BJM SECURITIES (PTY) LTD
D 00000000 E 00000000
BD850390000009
BD860390000009
BD770390000009 00000000 0000000
0000000000000000OTH00020010330 BJM SECURITIES (PTY)
BD780390000009B 00DM00
00000000000000000000000NC200 00000000
BD910390000009 000000000000000 000000000000000 000000000000000
000000000000000 000000000000000 000000000000000 000000000000000
Reply to this message...
 
    
ToddC@match.com
Just a guess, but it looks like a fixed length format.

tc

-----Original Message-----
From: Greg [mailto:Click here to reveal e-mail address]
Sent: Friday, July 12, 2002 1:42 PM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] Trouble importing file

I have copied a shortened version of the text file I am trying to import
into my SQL Server database. I can't figure this file format out, can
anybody help me here?, I have no documentation on this file.
2002/05/15 02:29:30 20020514

BD800390000006B 00 FINSTRUCT SECURITIES (PTY) LTD
D 00000000 00000000
BD850390000006

BD860390000006

BD770390000006 00000000 0000000
0000000000000000OTH00019990929

BD780390000006N 00DM00
00000000000000000000000 C200 00000000
BD910390000006 000000000000000 000000000000000 000000000000000
000000000000000 000000000000000 000000000000000 000000000000000

BD800390000007B 00 CLSA GLOBAL EMERGING MARKETS.
D 00000000 00000000
BD850390000007

BD860390000007

BD770390000007 00000000 0000000
0000000000000000OTH00019991105 CLSA GLOBAL EMERGING

BD780390000007N 00DM00
00000000000000000000000 C200 00000000
BD910390000007 000000000000000 000000000000000 000000000000000
000000000000000 000000000000000 000000000000000 000000000000000

BD800390000008B 00 SG SECURITIES (JOHANNESBURG) (PTY)
LTD. D 00000000 E
00000000
BD850390000008

BD860390000008

BD770390000008 00000000 0000000
0000000000000000OTH00020000926

BD780390000008N 00DM00
00000000000000000000000NC200 00000000 SGSA
BD910390000008 000000000000000 000000000000000 000000000000000
000000000000000 000000000000000 000000000000000 000000000000000

BD800390000009B 00 BJM SECURITIES (PTY) LTD
D 00000000 E 00000000
BD850390000009

BD860390000009

BD770390000009 00000000 0000000
0000000000000000OTH00020010330 BJM SECURITIES (PTY)

BD780390000009B 00DM00
00000000000000000000000NC200 00000000
BD910390000009 000000000000000 000000000000000 000000000000000
000000000000000 000000000000000 000000000000000 000000000000000

| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID |
http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT
Reply to this message...
 
    
robkoch@hotmail.com
Greg,

That looks like something FTP'ed out of a mainframe using a VSAM file
format. I've worked with those using VB as a front-end to a mainframe
system. Really awesome as the mainframe returns data so much faster than
a SQL Server with a comparative amount of information. If you've worked
in a old-guard banking or insurance industry, you'll see those all the
time...

Later!
-rob

Click here to reveal e-mail address
07/12/2002 05:12 PM EST
Please respond to "ngfx-sqlclient"

To: "ngfx-sqlclient" <Click here to reveal e-mail address>
cc:
Subject: [ngfx-sqlclient] RE: Trouble importing file

Just a guess, but it looks like a fixed length format.

tc

-----Original Message-----
From: Greg [mailto:Click here to reveal e-mail address]
Sent: Friday, July 12, 2002 1:42 PM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] Trouble importing file

I have copied a shortened version of the text file I am trying to import into my SQL
Server database. I can't figure this file format out, can anybody help me
here?, I have no documentation on this file.
2002/05/15 02:29:30 20020514
BD800390000006B 00 FINSTRUCT SECURITIES (PTY) LTD
D 00000000 00000000
BD850390000006
BD860390000006
BD770390000006 00000000 0000000
0000000000000000OTH00019990929
BD780390000006N 00DM00 00000000000000000000000 C200
00000000
BD910390000006 000000000000000 000000000000000 000000000000000
000000000000000 000000000000000 000000000000000 000000000000000
BD800390000007B 00 CLSA GLOBAL EMERGING MARKETS.
D 00000000 00000000
BD850390000007
BD860390000007
BD770390000007 00000000 0000000
0000000000000000OTH00019991105 CLSA GLOBAL EMERGING
BD780390000007N 00DM00 00000000000000000000000 C200
00000000
BD910390000007 000000000000000 000000000000000 000000000000000
000000000000000 000000000000000 000000000000000 000000000000000
BD800390000008B 00 SG SECURITIES (JOHANNESBURG)
(PTY) LTD. D 00000000 E 00000000

BD850390000008
BD860390000008
BD770390000008 00000000 0000000
0000000000000000OTH00020000926
BD780390000008N 00DM00 00000000000000000000000NC200
00000000 SGSA
BD910390000008 000000000000000 000000000000000 000000000000000
000000000000000 000000000000000 000000000000000 000000000000000
BD800390000009B 00 BJM SECURITIES (PTY) LTD D
00000000 E 00000000
BD850390000009
BD860390000009
BD770390000009 00000000 0000000
0000000000000000OTH00020010330 BJM SECURITIES (PTY)
BD780390000009B 00DM00 00000000000000000000000NC200
00000000
BD910390000009 000000000000000 000000000000000 000000000000000
000000000000000 000000000000000 000000000000000 000000000000000

| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID | http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT
| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID | http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT
Reply to this message...
 
 




Ad
MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT
 
 Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com