how to create a flat file

how to creat a flat file,

Madhumadhu0 pointsBadges:

Wireless access point to connect 30 devices at a time

Which is the best access point to connect 30 devices at a time, just for normal Internet access/email? Can I use Linksys WAP300N N300?

nik15r75 pointsBadges:

How to connect my application using Visual Studio 2005 to a SQL Server database?

how to connect my application using visual studio 2005 to a database using sql server?

MissVeryLittleKnowledge5 pointsBadges:

How to export data from AS/400 in Excel

Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

Itriconewbie5 pointsBadges:

ODBC Error Message Windows Server 2003

ODBC error:   "OLE IDispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.."

Gina35 pointsBadges:

Why Oracle E-Business database tables do not have primary and foreign keys?

Hello, I would like to know why there are no primary and foreign keys defined in Oracle E-Business database tables? Appreciate any insight. Regards, Jacob

JacobElias5 pointsBadges:

How will you test and approve MySQL tables to Elastic Search

In our e-commerce company, the DevOps engineer were facing a lot of trouble managing certain tables in MySQL namely logs_users, logs_actions which store logs of each visitor who comes to their e-commerce store. In an year's time the table size grew to 70GB. We hired a senior DevOps and when he...

sarthak3130 pointsBadges:

Trigger

What is the use of the trigger?

swamy00725 pointsBadges:

DB2/400: List of primary and foreign keys within schema

How can I get a list of primary and foreign keys within schema in DB2/400?

peterlk5 pointsBadges:

SQL query: Pull data in null column

I have a table with 4 columns. Two have data in it with margin record and not mar. The other two col is null. I need to put data in null column that mar. RecA RealRecord RecB misRecors 2345 2345 2456 2346 3456 3456 4567 4568

GK201315 pointsBadges:

Microsoft Access: How to add a table that lessen the room’s availability?

I have a table in access showing the rooms with a field: roomID, price and availability. And another table showing the transaction: TransactionID, CustomerID and RoomID. How to less the room's availability if I input the roomId in the transaction table?

euhipolito5 pointsBadges:

Importing Excel to Access auto populating data

I have imported an Excel spreadsheet into Access (2016) and am trying to figure out how to populate data. For example, I imported a spreadsheet containing employee name, ID, Department, Supervisor. If I select the employee name, I want my form to automatically populate with the rest of the data....

motogirl15 pointsBadges:

Certification sites for Synon?

Hello, Please can anyone suggest some good certification sites or courses for Synon or DB2 400. Except the ones from IBM. Synon is more broadly needed!!

Jammypune5 pointsBadges:

AS/400 – DB2/400 PF and LF have different identifiers for Synon

Hi, AS/400 -DB2/400--> PF and LF have different identifiers for files generated in Synon. But for the Manually created files PF and LF have same file level identifiers. Please let me know why it goes like this. Any idea? Looking answer for this. Thanks P.Amutha

As400pgmmer310 pointsBadges:

Synon/Cool:2E – internal/external func performance question

I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external...

Rituraj0 pointsBadges:

Cannot install MySQL on Windows 7

I've been trying to install MySQL on Windows 7. I'm getting to the reconfigure window, followed by the types and networking dialog page. But then the entire installation stops. I can't click the next button. What can I do?

ITKE1,067,645 pointsBadges:

SYNON vs COBOL

Hi All, This query is related to performance. I am currently in the process of changing an application from COBOL to Synon. The application uses a lot of I/O involving files. Upon converting the application to Synon, I find that the performance has declined - COBOL takes 8 minutes whereas Synon is...

Rituraj0 pointsBadges:

Shortcut to apply Microsoft Access 2013 filters

For Access 2013, does anyone know if I would be able to create a shortcut to activate filters by form / apply filters? Basically, for all filter actions. Thanks!

ITKE1,067,645 pointsBadges:

Define relation in Microsoft Access

In Microsoft Access, what is meant by define relation?

farasathussaintaajwar5 pointsBadges:

Convert AS/400 file to Excel and PDF

I would like to transfer a PF data into Excel but my add-ins not working. Can you provide me any other ways to do that?

As400programm10 pointsBadges: