.Q.s \c limitation workaround

Community Support
1

I have a table with lots of cols and output is cutoff because of \c limitation of .Q.s . Is there a way around it ?

2

Such table is arguably not suitable for console output – one will have great difficulty deciphering so much content on the screen.

Besides adjusting \c to allow larger console size, I don’t think there is other ways built-in to q to allow such case. You can as easily use an IDE for such case instead.

3

I think you can use -1 to exceel \c capacity but I was looking for something popular off the internet.

4

X-OriginatorOrg: aquaq.co.ukX-MS-Exchange-CrossTenant-originalarrivaltime: 03 Oct 2017 11:00:48.4480 (UTC)X-MS-Exchange-CrossTenant-fromentityheader: HostedX-MS-Exchange-CrossTenant-id: 1fe461f8-73a6-46f7-8acf-4c7ee683b608X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM4PR01MB1553SGkNCg0KT25lIHdheSB0byBkbyB0aGlzIHdvdWxkIGJlIHRvIHVzZSAuUS5TIGluc3RlYWQgb2YgLlEucw0KDQouUS5TIHVuZGVybGllcyB0aGUgLlEucyBmdW5jdGlvbiwgYW5kIGNhbiBiZSBwYXNzZWQgYXJiaXRyYXJ5IGxpbWl0cyAoaW5zaWRlIC5RLnMgdGhpcyBpcyBjYWxsZWQgdXNpbmcgdGhlIGNvbnNvbGUgc2l6ZSBhcyB0aGUgbGltaXRzKQ0KDQouUS5TIHRha2VzIDMgYXJndW1lbnRzOg0KDQpYIGlzIGEgdHdvIGl0ZW0gbGlzdCBvZiBoZWlnaHQgYW5kIHdpZHRoDQpZIGlzIHRoZSBpbmRleCB3aXRoaW4gWiB0byBzdGFydCBhdCAoaS5lLiB5b3UgcHJvYmFibHkgd2FudCAwKQ0KWiBpcyB0aGUgb2JqZWN0IHRvIGJlIG1hZGUgaW50byBhIHN0cmluZw0KDQpTbyBlLmcuIHlvdSBjb3VsZCB1c2UNCg0KcSkuUS5TWzEwMDAgMTAwMDswXSB0YWJsZQ0KDQp0byBnZW5lcmF0ZSBhIHN0cmluZyBmcm9tIGEgdGFibGUgd2l0aCBsaW1pdHMgb2YgMTAwMCBjaGFycyBmb3IgaGVpZ2h0IGFuZCB3aWR0aA0KDQpOb3RlIHRoYXQgdGhlIG91dHB1dCB3aWxsIGJlIGEgbGlzdCBvZiBzdHJpbmdzLCByYXRoZXIgdGhhbiBhIHNpbmdsZSBcbiBkZWxpbWl0ZWQgc3RyaW5nIGFzIHdpdGggLlEucy4gWW91IGNhbiBjb252ZXJ0IHRvIGEgc2luZ2xlIFxuIGRlbGltaXRlZCBzdHJpbmcgbGlrZSBzbzoNCg0KcSlgIHN2IC5RLlNbMTAwMCAxMDAwOzBdIHRhYmxlDQoNCkhvcGUgdGhpcyBoZWxwcw0KSm9uYXRob24NCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IHBlcnNvbmFsLWtkYnBsdXNAZ29vZ2xlZ3JvdXBzLmNvbSBbbWFpbHRvOnBlcnNvbmFsLWtkYnBsdXNAZ29vZ2xlZ3JvdXBzLmNvbV0gT24gQmVoYWxmIE9mIGNwcGhleUBnbWFpbC5jb20NClNlbnQ6IDAzIE9jdG9iZXIgMjAxNyAwNjowNQ0KVG86IEtkYisgUGVyc29uYWwgRGV2ZWxvcGVycyA8cGVyc29uYWwta2RicGx1c0Bnb29nbGVncm91cHMuY29tPg0KU3ViamVjdDogW3BlcnNvbmFsIGtkYitdIFJlOiAuUS5zIFxjIGxpbWl0YXRpb24gd29ya2Fyb3VuZA0KDQpJIHRoaW5rIHlvdSBjYW4gdXNlIC0xIHRvIGV4Y2VlbCBcYyBjYXBhY2l0eSBidXQgSSB3YXMgbG9va2luZyBmb3Igc29tZXRoaW5nIHBvcHVsYXIgb2ZmIHRoZSBpbnRlcm5ldC4NCg0KLS0NCllvdSByZWNlaXZlZCB0aGlzIG1lc3NhZ2UgYmVjYXVzZSB5b3UgYXJlIHN1YnNjcmliZWQgdG8gdGhlIEdvb2dsZSBHcm91cHMgIktkYisgUGVyc29uYWwgRGV2ZWxvcGVycyIgZ3JvdXAuDQpUbyB1bnN1YnNjcmliZSBmcm9tIHRoaXMgZ3JvdXAgYW5kIHN0b3AgcmVjZWl2aW5nIGVtYWlscyBmcm9tIGl0LCBzZW5kIGFuIGVtYWlsIHRvIHBlcnNvbmFsLWtkYnBsdXMrdW5zdWJzY3JpYmVAZ29vZ2xlZ3JvdXBzLmNvbS4NClRvIHBvc3QgdG8gdGhpcyBncm91cCwgc2VuZCBlbWFpbCB0byBwZXJzb25hbC1rZGJwbHVzQGdvb2dsZWdyb3Vwcy5jb20uDQpWaXNpdCB0aGlzIGdyb3VwIGF0IGh0dHBzOi8vZ3JvdXBzLmdvb2dsZS5jb20vZ3JvdXAvcGVyc29uYWwta2RicGx1cy4NCkZvciBtb3JlIG9wdGlvbnMsIHZpc2l0IGh0dHBzOi8vZ3JvdXBzLmdvb2dsZS5jb20vZC9vcHRvdXQuDQoNClRoaXMgZS1tYWlsIG1lc3NhZ2UgaXMgaW50ZW5kZWQgdG8gYmUgcmVjZWl2ZWQgb25seSBieSBwZXJzb25zIGVudGl0bGVkIHRvIHJlY2VpdmUgdGhlIGNvbmZpZGVudGlhbCBpbmZvcm1hdGlvbiBpdCBtYXkgY29udGFpbi4gRS1tYWlsIG1lc3NhZ2VzIHRvIGNsaWVudHMgb2YgQXF1YVEgQW5hbHl0aWNzIG1heSBjb250YWluIGluZm9ybWF0aW9uIHRoYXQgaXMgY29uZmlkZW50aWFsIGFuZCBsZWdhbGx5IHByaXZpbGVnZWQuIFBsZWFzZSBkbyBub3QgcmVhZCwgY29weSwgZm9yd2FyZCwgb3Igc3RvcmUgdGhpcyBtZXNzYWdlIHVubGVzcyB5b3UgYXJlIGFuIGludGVuZGVkIHJlY2lwaWVudCBvZiBpdC4gSWYgeW91IGhhdmUgcmVjZWl2ZWQgdGhpcyBtZXNzYWdlIGluIGVycm9yLCBwbGVhc2UgZm9yd2FyZCBpdCB0byB0aGUgc2VuZGVyIGFuZCBkZWxldGUgaXQgY29tcGxldGVseSBmcm9tIHlvdXIgY29tcHV0ZXIgc3lzdGVtLg0K

5

Hi,

Would you mind providing an example of how you would exceed \c capacity with -1? I’ve attempted something along the lines of -1[-3!tblName] with no luck.


Thanks,


Collin