teradata257.rssing.com
Open in
urlscan Pro
185.150.190.192
Public Scan
Submitted URL: https://teradata257.rssing.com/
Effective URL: https://teradata257.rssing.com/chan-4168456/index-latest.php
Submission: On September 19 via api from US — Scanned from DE
Effective URL: https://teradata257.rssing.com/chan-4168456/index-latest.php
Submission: On September 19 via api from US — Scanned from DE
Form analysis 10 forms found in the DOM
Name: hmsearch — GET
<form name="hmsearch" method="get">
<input type="text" name="q" id="cs-header-menu-search-form-input" placeholder="Type and press enter..." value="" onkeydown="return dogsearch_if13(document.hmsearch.q.value, document.hmsearch.stype.value, event.keyCode);">
<input type="text" name="dummy" style="visibility:hidden">
<select name="stype" style="visibility:hidden">
<option selected="" value="rssing.com">RSSing.com</option>
</select>
</form>Name: searchbox_1 — GET
<form name="searchbox_1" method="get">
<div class="input-group wrapped-text-input">
<input type="text" name="q" placeholder="search RSSing.com...." value="" onkeydown="return dogsearch_if13(document.searchbox_1.q.value, document.searchbox_1.stype.value,event.keyCode);">
<div class="input-group-prepend">
<a class="cs-btn cs-btn-medium " href="javascript:;" onclick="dogsearch(document.searchbox_1.q.value, document.searchbox_1.stype.value);">Search</a>
</div>
</div>
<input type="text" name="dummy" style="display:none">
<select name="stype" style="display:none">
<option selected="" value="rssing.com">RSSing.com</option>
</select>
</form>Name: searchbox_2 — GET
<form name="searchbox_2" method="get">
<div class="input-group wrapped-text-input">
<input type="text" name="q" placeholder="search RSSing.com...." value="" onkeydown="return dogsearch_if13(document.searchbox_2.q.value, document.searchbox_2.stype.value,event.keyCode);">
<div class="input-group-prepend">
<a class="cs-btn cs-btn-medium " href="javascript:;" onclick="dogsearch(document.searchbox_2.q.value, document.searchbox_2.stype.value);">Search</a>
</div>
</div>
<input type="text" name="dummy" style="display:none">
<select name="stype" style="display:none">
<option selected="" value="rssing.com">RSSing.com</option>
</select>
</form>Name: searchbox_3 — GET
<form name="searchbox_3" method="get">
<div class="input-group wrapped-text-input">
<input type="text" name="q" placeholder="search RSSing.com...." value="" onkeydown="return dogsearch_if13(document.searchbox_3.q.value, document.searchbox_3.stype.value,event.keyCode);">
<div class="input-group-prepend">
<a class="cs-btn cs-btn-medium " href="javascript:;" onclick="dogsearch(document.searchbox_3.q.value, document.searchbox_3.stype.value);">Search</a>
</div>
</div>
<input type="text" name="dummy" style="display:none">
<select name="stype" style="display:none">
<option selected="" value="rssing.com">RSSing.com</option>
</select>
</form>Name: searchbox_4 — GET
<form name="searchbox_4" method="get">
<div class="input-group wrapped-text-input">
<input type="text" name="q" placeholder="search RSSing.com...." value="" onkeydown="return dogsearch_if13(document.searchbox_4.q.value, document.searchbox_4.stype.value,event.keyCode);">
<div class="input-group-prepend">
<a class="cs-btn cs-btn-medium " href="javascript:;" onclick="dogsearch(document.searchbox_4.q.value, document.searchbox_4.stype.value);">Search</a>
</div>
</div>
<input type="text" name="dummy" style="display:none">
<select name="stype" style="display:none">
<option selected="" value="rssing.com">RSSing.com</option>
</select>
</form>Name: searchbox_5 — GET
<form name="searchbox_5" method="get">
<div class="input-group wrapped-text-input">
<input type="text" name="q" placeholder="search RSSing.com...." value="" onkeydown="return dogsearch_if13(document.searchbox_5.q.value, document.searchbox_5.stype.value,event.keyCode);">
<div class="input-group-prepend">
<a class="cs-btn cs-btn-medium " href="javascript:;" onclick="dogsearch(document.searchbox_5.q.value, document.searchbox_5.stype.value);">Search</a>
</div>
</div>
<input type="text" name="dummy" style="display:none">
<select name="stype" style="display:none">
<option selected="" value="rssing.com">RSSing.com</option>
</select>
</form>Name: searchbox_6 — GET
<form name="searchbox_6" method="get">
<div class="input-group wrapped-text-input">
<input type="text" name="q" placeholder="search RSSing.com...." value="" onkeydown="return dogsearch_if13(document.searchbox_6.q.value, document.searchbox_6.stype.value,event.keyCode);">
<div class="input-group-prepend">
<a class="cs-btn cs-btn-medium " href="javascript:;" onclick="dogsearch(document.searchbox_6.q.value, document.searchbox_6.stype.value);">Search</a>
</div>
</div>
<input type="text" name="dummy" style="display:none">
<select name="stype" style="display:none">
<option selected="" value="rssing.com">RSSing.com</option>
</select>
</form>Name: searchbox_7 — GET
<form name="searchbox_7" method="get">
<div class="input-group wrapped-text-input">
<input type="text" name="q" placeholder="search RSSing.com...." value="" onkeydown="return dogsearch_if13(document.searchbox_7.q.value, document.searchbox_7.stype.value,event.keyCode);">
<div class="input-group-prepend">
<a class="cs-btn cs-btn-medium " href="javascript:;" onclick="dogsearch(document.searchbox_7.q.value, document.searchbox_7.stype.value);">Search</a>
</div>
</div>
<input type="text" name="dummy" style="display:none">
<select name="stype" style="display:none">
<option selected="" value="rssing.com">RSSing.com</option>
</select>
</form>Name: searchbox_8 — GET
<form name="searchbox_8" method="get">
<div class="input-group wrapped-text-input">
<input type="text" name="q" placeholder="search RSSing.com...." value="" onkeydown="return dogsearch_if13(document.searchbox_8.q.value, document.searchbox_8.stype.value,event.keyCode);">
<div class="input-group-prepend">
<a class="cs-btn cs-btn-medium " href="javascript:;" onclick="dogsearch(document.searchbox_8.q.value, document.searchbox_8.stype.value);">Search</a>
</div>
</div>
<input type="text" name="dummy" style="display:none">
<select name="stype" style="display:none">
<option selected="" value="rssing.com">RSSing.com</option>
</select>
</form>Name: searchbox_9 — GET
<form name="searchbox_9" method="get">
<div class="input-group wrapped-text-input">
<input type="text" name="q" placeholder="search RSSing.com...." value="" onkeydown="return dogsearch_if13(document.searchbox_9.q.value, document.searchbox_9.stype.value,event.keyCode);">
<div class="input-group-prepend">
<a class="cs-btn cs-btn-medium " href="javascript:;" onclick="dogsearch(document.searchbox_9.q.value, document.searchbox_9.stype.value);">Search</a>
</div>
</div>
<input type="text" name="dummy" style="display:none">
<select name="stype" style="display:none">
<option selected="" value="rssing.com">RSSing.com</option>
</select>
</form>Text Content
WE VALUE YOUR PRIVACY We and our partners store and/or access information on a device, such as cookies and process personal data, such as unique identifiers and standard information sent by a device for personalised ads and content, ad and content measurement, and audience insights, as well as to develop and improve products. With your permission we and our partners may use precise geolocation data and identification through device scanning. You may click to consent to our and our partners’ processing as described above. Alternatively you may click to refuse to consent or access more detailed information and change your preferences before consenting. Please note that some processing of your personal data may not require your consent, but you have a right to object to such processing. Your preferences will apply to this website only. You can change your preferences at any time by returning to this site or visit our privacy policy. MORE OPTIONSDISAGREEAGREE * Login * Account * Sign Up * Home * About Us * Catalog * Search * Register RSS * Embed RSS * FAQ * Get Embed Code * Example: Default CSS * Example: Custom CSS * Example: Custom CSS per Embedding * Super RSS * Usage * View Latest * Create * Contact Us * Technical Support * Guest Posts/Articles * Report Violations * Google Warnings * Article Removal Requests * Channel Removal Requests * General Questions * DMCA Takedown Notice * RSSing>> * Collections: * RSSing * EDA * Intel * Mesothelioma * SAP * SEO * Latest * Articles * Channels * Super Channels * Popular * Articles * Pages * Channels * Super Channels * Top Rated * Articles * Pages * Channels * Super Channels * Trending * Articles * Pages * Channels * Super Channels Switch Editions? German Edition (Deutsch) Cancel AddThis Sharing Buttons Share to FacebookFacebookShare to TwitterTwitterShare to PrintPrintShare to EmailEmailShare to PinterestPinterestShare to GmailGmailShare to LinkedInLinkedInShare to Email AppEmail AppShare to TumblrTumblrShare to MoreAddThis English RSSing.com RSSing>> Latest Popular Top Rated Trending Channel: Teradata Forums - All forums SUBSCRIBE Remove ADS NSFW? Claim 1 Mark channel Not-Safe-For-Work? cancel confirm NSFW Votes: (0 votes) Are you the publisher? Claim or contact us about this channel. 3.0 stars on 1 votes Showing 50 articles in the latest snapshot of channel 4168456 Channel Details: * Title: Teradata Forums - All forums * Channel Number: 4168456 * Language: eng * Registered On: September 3, 2012, 2:52 pm * Number of Articles: 27759 * Latest Snapshot: September 8, 2016, 2:19 am * RSS URL: http://forums.teradata.com/forum/rss.xml * Publisher: /forum * Description: All forum topics and responses * Catalog: //teradata257.rssing.com/catalog.php?indx=4168456 Browsing latest articles Browse All 27759 View Live -------------------------------------------------------------------------------- OLAP SQL - RUNNING COUNT/TOTAL - FORUM TOPIC BY DEVEN_RK :0 :0 September 5, 2016, 8:24 am Hi All, We have the below data and using an SQL not procedural code, I would like to get the output as given below for 'out_count', it would help if we could do it using OLAP functions with... View Article -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- Search RSSing.com -------------------------------------------------------------------------------- OLAP SQL - RUNNING COUNT/TOTAL - FORUM TOPIC BY DEVEN_RK :0 :0 September 5, 2016, 8:26 am Hi All, We have the below data and using an SQL not procedural code, I would like to get the output as given below for 'out_count', it would help if we could do it using OLAP functions with... View Article -------------------------------------------------------------------------------- LOG FILE AFTER SHUTDOWN - FORUM TOPIC BY KNOWLEDGE :0 :0 September 5, 2016, 9:18 am Hi, i need to have a complete log for the system and users activities on ASTER. i need it because after a shutdown in the weekend, i think for too many sessions or too many work space used, i can't... View Article -------------------------------------------------------------------------------- TPT MULTIPLE JOBVAR FILES - FORUM TOPIC BY COLINPRETTY :0 :0 September 6, 2016, 1:56 am Hi there, I'm new to TPT and have got it working. I'm wanting to use Job Variable files to house things such as username and password and have got this working with the main script by using tbuild -f... View Article -------------------------------------------------------------------------------- HOW TO RETURN THE RESULT OF A SELECT QUERY IN A FUNCTION - FORUM TOPIC BY... :0 :0 September 6, 2016, 3:14 am Hello to everybody, I'm trying to return the result of a select query in a function. Something like: REPLACE FUNCTION F_SIGUIPUNTERO_F (nPunt number, nLimite number) RETURNS int LANGUAGE SQL CONTAINS... View Article -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- OLAP SQL - RUNNING COUNT/TOTAL - RESPONSE (1) BY NEALVENNA :0 :0 September 6, 2016, 7:02 am Below is the solution and answer is inspired from Dieter Answer from the link below https://forums.teradata.com/forum/database/olap-function-csum-sum-with-reset-value select cal_date,... View Article -------------------------------------------------------------------------------- OPTION "USER CHOICE (INCLUDES DBC)" NOT AVAILABLE IN TERADATA STUDIO 15.11 -... :0 :0 September 6, 2016, 7:12 am Is the "Show Databases and Users In Hierarchical Display" box checked? If so, uncheck that, and then "User Choice" should be available as an option. View Article -------------------------------------------------------------------------------- TERADATA BLOCK STORAGE - RESPONSE (1) BY TODDAWALTER :0 :0 September 6, 2016, 7:25 am The rows in the data blocks are not sorted, they are just placed at the end of a heap of storage. The block contains an index list though which is ordered by the rowid. Likewise the blocks are not... View Article -------------------------------------------------------------------------------- Search RSSing.com -------------------------------------------------------------------------------- TERDATA STUDIO EXPRESS LAGGY ON MAC - RESPONSE (5) BY FGRIMMER :0 :0 September 6, 2016, 8:52 am Jing, It sounds like you have tried a lot of the suggestions! We hope to have fixed the SQL Editor issue in our upcoming 15.12 release (due out this week), regarding a double-click problem.... View Article -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- OPTION "USER CHOICE (INCLUDES DBC)" NOT AVAILABLE IN TERADATA STUDIO 15.11 -... :0 :0 September 6, 2016, 9:09 am Xinyu, A response was posted by Angela, but it was "unpublised" for some reason, so I will repeat what the solution is: Make sure that the "Show Databases and Users in Hierarchcial Display" is... View Article -------------------------------------------------------------------------------- ARCMAIN - FORUM TOPIC BY ARTEAGA7 :0 :0 September 6, 2016, 11:16 am I need to perform a database backup but I am not able to find a place to download the tool or a package containing the tool. I think it might be included in a previous version of the utilities but I am... View Article -------------------------------------------------------------------------------- CONVERTING UNIX/EPOCH TIME TO PST - FORUM TOPIC BY MANISH237 :0 :0 September 6, 2016, 11:51 am I have a column in my teradata table which stores timestamp in UNIX/EPOCH form. I want to run a query and get the corresponding Date in PST and number of records against that date. I got the following... View Article -------------------------------------------------------------------------------- TPT MULTIPLE JOBVAR FILES - RESPONSE (1) BY FEINHOLZ :0 :0 September 6, 2016, 12:09 pm Yes, TPT does support multiple job variable files. You just add additional -v <filename> command line options to the command line. This feature was implemented recently (targeted for 16.0), but... View Article -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- CREATING A DYNAMIC YOY DATE RANGE IN CASE STATEMENT FOR CURRENT QUARTER QTD -... :0 :0 September 6, 2016, 12:34 pm Thank you Dieter this works! View Article -------------------------------------------------------------------------------- SYNTAX - FORUM TOPIC BY SGIT :0 :0 September 6, 2016, 1:36 pm I am getting the following error : SPL1027:E(L7), Missing/Invalid SQL statement'E(3706):Syntax error: expected something between the word 'StartDate' and the 'DATE' keyword.'. Looks like a syntax... View Article -------------------------------------------------------------------------------- Search RSSing.com -------------------------------------------------------------------------------- FIND BLOCKING SESSIONS AND TABLES - FORUM TOPIC BY TERADATAUSER2 :0 :0 September 6, 2016, 3:42 pm Hi, In our environment, we have an application that runs queries and they block each other for some tables. I want to know which all sessions and which all tables are in blocked state with that ID? i... View Article -------------------------------------------------------------------------------- FIND BLOCKING SESSIONS AND TABLES - RESPONSE (1) BY TERADATAUSER2 :0 :0 September 6, 2016, 3:52 pm I see the values as blk3objdbid = 1 and blk3objtid = 102, screenshot attached View Article -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- BTEQ:SAVING OUTPUT IN MULTIPLE FILE - FORUM TOPIC BY VC :0 :0 September 6, 2016, 9:49 pm Hello All. I am writing a bteq which is saving the output in the One file.Bteq has 3 different queries. I need to save outout of all the three queries in three seprate files using one BTEQ.is it... View Article -------------------------------------------------------------------------------- FIND SKEW WITH PERM OVER 1GB - FORUM TOPIC BY VC :0 :0 September 6, 2016, 10:45 pm Hello, I am using the below query SELECT cast(DatabaseName as char(30)), cast(Tablename as char(40)), (100 - (AVG(CURRENTPERM)/MAX(CURRENTPERM)*100) (FORMAT 'zz9.99') )AS Skewfactor_greater_90, cast... View Article -------------------------------------------------------------------------------- FIND SKEW WITH PERM OVER 1GB - RESPONSE (1) BY ATARDECERR0J0 :0 :0 September 7, 2016, 12:55 am SELECT cast(DatabaseName as char(30)), cast(Tablename as char(40)), (100 - (AVG(CURRENTPERM)/MAX(CURRENTPERM)*100) (FORMAT 'zz9.99') )AS Skewfactor_greater_90, cast (CURRENT_date as timestamp(0)) +... View Article -------------------------------------------------------------------------------- SYSTEM TABLE FOR COMPRESSION - FORUM TOPIC BY AGTS :0 :0 September 7, 2016, 2:02 am Is there any way for finding compressed columns in database with there values, like system table for compression columns and values? using Select * from dbc.columns where compressible like 'C%'; I can... View Article -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- SYSTEM TABLE FOR COMPRESSION - RESPONSE (1) BY AGTS :0 :0 September 7, 2016, 2:27 am got it. CompressValueList in dbc.columns can be use for same View Article -------------------------------------------------------------------------------- Search RSSing.com -------------------------------------------------------------------------------- DROP TABLE BLOCKED BY READ LOCK SESSION WHICH IS NOT ON THE MACHINE. - FORUM... :0 :0 September 7, 2016, 3:07 am Hi All, I having an issues, while Dropping a backup table, The drop tables session(Session ID 59678567) is blocked by read lock of some other session (2463583 USER: ALL), this blocking is not even... View Article -------------------------------------------------------------------------------- TERADATA BLOCK STORAGE - RESPONSE (2) BY PANDIT :0 :0 September 7, 2016, 3:15 am Thanks a lot for the reply Todd. It was really helpful. Just to revise, say on block level, data will be just apended to blocks whereas the index will be in sorted order for performing binary search.... View Article -------------------------------------------------------------------------------- WORKING WITH XMLTABLE, PROBLEM EXTRACTING DATA WHERE ELEMENTS HAVE NO... :0 :0 September 7, 2016, 3:23 am I am working on an XML parsing requirement using XML Table. I am running into a problem with data from elements with no namespaces or prefixes. Extraction using XMLTable doesn't seem to work.... View Article -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ARCMAIN - RESPONSE (1) BY GLASS :0 :0 September 7, 2016, 5:31 am You can find all TTU downloads at T@YS Rglass View Article -------------------------------------------------------------------------------- COLLECT STATS WITH INSERT STATEMENT - FORUM TOPIC BY AGANEDIWAL :0 :0 September 7, 2016, 5:39 am Hi all, I am using below two statements to create table and insert some data from an existing table. Is there a way in which stats will be automatically collected after insert statement completes or a... View Article -------------------------------------------------------------------------------- HAVING AN ISSUE WITH CHAR,VARCHAR,DATE DATA TYPES WHILE EXPORTING/IMPORTING... :0 :0 September 7, 2016, 6:32 am Hello, I am trying to Import/Export Tables from/to Teradata into Hive. But If Hive table has CHAR/VARCHAR/DATE data types, I am getting below error from TDCH Connector INFO tool.ConnectorExportTool:... View Article -------------------------------------------------------------------------------- COMPUTE WITH IMMEDIATE PREVIOUS ROW VALUE DERIVED - FORUM TOPIC BY DEVEN_RK :0 :0 September 7, 2016, 7:58 am Hi All, I have the below data, wherein I want to compute 'Amount' data dynamically in a 'Select' statement as given below, here I want to refer the previous row value, apply an equation, compute a... View Article -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- Search RSSing.com -------------------------------------------------------------------------------- COMPUTE WITH IMMEDIATE PREVIOUS ROW VALUE DERIVED - FORUM TOPIC BY DEVEN_RK :0 :0 September 7, 2016, 7:58 am Hi All, I have the below data, wherein I want to compute 'Amount' data dynamically in a 'Select' statement as given below, here I want to refer the previous row value, apply an equation, compute a... View Article -------------------------------------------------------------------------------- TERADATA BLOCK STORAGE - RESPONSE (3) BY TODDAWALTER :0 :0 September 7, 2016, 7:59 am Correct. The row index list is just a set of offsets from the beginning of the block rather than a pointer but the effect is the same. View Article -------------------------------------------------------------------------------- FIND BLOCKING SESSIONS AND TABLES - RESPONSE (3) BY TERADATAUSER2 :0 :0 September 7, 2016, 8:38 am Could anyone please help me on this ? --samir View Article -------------------------------------------------------------------------------- ARCMAIN - RESPONSE (2) BY ARTEAGA7 :0 :0 September 7, 2016, 8:49 am What does T@YS mean? Do you have a sample script you use to backup a teradata database instance? View Article -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- COMPUTE WITH IMMEDIATE PREVIOUS ROW VALUE DERIVED - RESPONSE (1) BY... :0 :0 September 7, 2016, 9:31 am Let say your table has first record (2016-11-01, 1000) then you can run the below SQL once everyday which will calculate new Amount and insert it into the same table. INS into dbname.Amt_tbl Sel... View Article -------------------------------------------------------------------------------- CONVERTING UNIX/EPOCH TIME TO PST - RESPONSE (1) BY TOMNOLAN :0 :0 September 7, 2016, 9:51 am You said that you wanted to get the "PST date", but time zones are not associated with DATE values. In other words, the Teradata Database does not offer a DATE WITH TIME ZONE data type. Your outermost... View Article -------------------------------------------------------------------------------- ARCMAIN - RESPONSE (3) BY VANDEBERGB :0 :0 September 7, 2016, 10:24 am T@YS = Teradata At Your Service Somebody in your organization, probably the lead DBA should have an account set up to download all the wonders of TD documentation, hotfixes and new releases... View Article -------------------------------------------------------------------------------- Search RSSing.com -------------------------------------------------------------------------------- FIND BLOCKING SESSIONS AND TABLES - RESPONSE (4) BY ABHISHEK.JADHAV :0 :0 September 7, 2016, 10:39 am You can use following functions to map the ids to names IdentifyTable IdentifyDatabase dbid=1 is for DBC tid=102 is for AccessRights table View Article -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- VOLATILE TABLES INSIDE THE STORED PROCEDURE - FORUM TOPIC BY SGIT :0 :0 September 7, 2016, 11:16 am Hello, I have the following two questions please: 1) While creating a volatile talbe inside a stored procedure : it needs to be created first outside the SP and then again inside. I am doing this... View Article -------------------------------------------------------------------------------- COMPUTE WITH IMMEDIATE PREVIOUS ROW VALUE DERIVED - RESPONSE (2) BY DNOETH :0 :0 September 7, 2016, 12:24 pm Your calculation is similar to 1000 * 1.1 ** (row_number() over (order by Date)-1) To get he start value you might try min(Amount) over () * 1.1 ** (row_number() over (order by Date)-1) or... View Article -------------------------------------------------------------------------------- FASTLOAD - DATA CONVERSIONS - FORUM TOPIC BY ZATKINSO :0 :0 September 7, 2016, 12:34 pm Hello, I am having issues performing data conversions specially with dates and timestamps while using fastload. My script is pasted below. All my rows are being imported and sent to error_1 table... View Article -------------------------------------------------------------------------------- FIND BLOCKING SESSIONS AND TABLES - RESPONSE (5) BY TERADATAUSER2 :0 :0 September 7, 2016, 1:18 pm Thanks Abhishek, it works. View Article -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- FASTLOAD - DATA CONVERSIONS - RESPONSE (1) BY FEINHOLZ :0 :0 September 7, 2016, 1:48 pm To which type of data conversions are you referring? The FastLoad script is just loading data. Teradata expects the Date/Time/Timestamp data to be in a very specific format. If the incoming data does... View Article -------------------------------------------------------------------------------- FASTLOAD - DATA CONVERSIONS - RESPONSE (2) BY ZATKINSO :0 :0 September 7, 2016, 2:06 pm Hey Steve, I am exporting the data from the same table. Creating a new empy version of the same table and fastloading the data that was exported from the original table. I am working on a tool to... View Article -------------------------------------------------------------------------------- Search RSSing.com -------------------------------------------------------------------------------- FASTLOAD - DATA CONVERSIONS - RESPONSE (3) BY ZATKINSO :0 :0 September 7, 2016, 2:25 pm Sorry to double post but I believe I side stepped your question. The data in the exported file is DATE with FORMAT 'YY/MM/DD'. The table has this same type and format. However, as I understand RECORD... View Article -------------------------------------------------------------------------------- COLLECT STATS WITH INSERT STATEMENT - RESPONSE (1) BY ABHISHEK.JADHAV :0 :0 September 7, 2016, 2:44 pm A third statement for collecting stats is required. View Article -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- COLLAPSE ONE TO MANY INTO ONE SQL QUERY RESULT ROW - FORUM TOPIC BY... :0 :0 September 7, 2016, 2:51 pm I would like to collapse records from a one to many relationship down into a single query result row, a task can have one or two resources assigned (there is no limit on the number of resources that... View Article -------------------------------------------------------------------------------- FASTLOAD - DATA CONVERSIONS - RESPONSE (4) BY FEINHOLZ :0 :0 September 7, 2016, 3:24 pm FastExport itself cannot export the data and write it out in delimited format. So, I guess you must be CASTing your SELECT statement. Do you have to use SQLAssistant? Have you tried TPT? Can you... View Article -------------------------------------------------------------------------------- CONNECTIVITY ISSUE - RESPONSE (3) BY CHEESE03 :0 :0 September 7, 2016, 6:45 pm Has you been able to resolve this issue? I am getting the exact same error? Even with the permissions on the file set to 0555,0777,4100 and 4100. View Article -------------------------------------------------------------------------------- WORKING WITH XMLTABLE, PROBLEM EXTRACTING DATA WHERE ELEMENTS HAVE NO... :0 :0 September 7, 2016, 11:13 pm Ok, after some experimentation, I think I fixed the issue... As I've mentioned, the above code is just mocked code I prepared for the purpose of demonstrating my issue. There is actually a defined... View Article -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- TPT MULTIPLE JOBVAR FILES - RESPONSE (2) BY COLINPRETTY :0 :0 September 8, 2016, 12:11 am I did forget to mention that I'm on 14 (soon to be upgrading to 15). I'm guessing that means I can't do it as yet, so I'll hold fire until then. Thanks for the response Steve. View Article -------------------------------------------------------------------------------- Search RSSing.com Browsing latest articles Browse All 27759 View Live -------------------------------------------------------------------------------- More Pages to Explore ..... * //papatoetoe10.rssing.com/chan-42156398/article59.html * //equipment82911.rssing.com/chan-71769926/article11.html * //bsides1164.rssing.com/chan-42155836/article25.html * //growing3074.rssing.com/chan-11703704/article7.html * //erfolg807.rssing.com/chan-38709719/index-latest.php * //bishies186.rssing.com/chan-38708983/index-latest.php * //africains95.rssing.com/chan-50702229/article17.html * //nekane111.rssing.com/chan-38708552/index-latest.php * //origamitree42.rssing.com/chan-71768817/index-latest.php * //monetica2.rssing.com/chan-50701604/article12.html * //informatico373.rssing.com/chan-42156477/article3.html * //visualizeus3079.rssing.com/chan-38709679/index-latest.php * //macmanx122.rssing.com/chan-42156350/article4.html * //indoek109.rssing.com/chan-50701774/index-page1.html * //pinoy2957.rssing.com/chan-50701790/index-page1.html * //nazareth272.rssing.com/chan-42156558/index-latest.php * //babygirl152.rssing.com/chan-50701731/index-page1.html * //vacancies2159.rssing.com/chan-42156355/article6.html * //dealbreaker1643.rssing.com/chan-23357998/index-latest.php * //markowa16.rssing.com/chan-50702413/index-latest.php -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- Search RSSing.com -------------------------------------------------------------------------------- * RSSing>> * Latest * Popular * Top Rated * Trending © 2022 //www.rssing.com