ExamGuru IT/.Net Guru : Trouble importing file on ASPFriends.com 'ngfx-sqlclient' list

.NETGURU

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...

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification