#DateForumTypeThreadPost
1425 Nov 2015 @ 11:48 PSTGeneralReplyUnassigned Work Load Definition For properly Configured User in TASM !!!!Added more details to my earlier questions.
1325 Nov 2015 @ 11:34 PSTGeneralReplyUnassigned Work Load Definition For properly Configured User in TASM !!!!Subhash,   I got exactly same situation. As Geeta mentioned, I checked at my end and I do not see any of those conditions (like user DBC, TDWM and etc; help, show.. My requests are data extra...
1210 Jan 2010 @ 01:16 PSTDatabaseReplytable updatesSearch in DBQL backup tables. Usually, DBA stores DBQL data in to non DBC tables on regular basis so you will be able to find details in those tables if your DBA is maintaining those tables.
1110 Jan 2010 @ 01:05 PSTToolsReplyFast Export & Fast loadingI would use delimeter in the fastexport select statement itself as follows.select item_id,',',item_codefrom Table....
1026 Aug 2009 @ 05:17 PDTDatabaseReplyTeradata stored proceduresDid this procedure work for you? what type privileges you had to get for the id that used to execute it?
924 Aug 2009 @ 02:29 PDTDatabaseTopicCompilation error while creating a stored procedureI have written the following procedure but experiencing the permission issue. Can someone help me what permissions I need to compile the folloiwng procedure?Error: SPL1078 - user is not authorized ...
822 Jul 2009 @ 02:07 PDTUDATopicTeradata V2 R13Has anybody upgraded to Terdata V2R13? If so, can you share the main features of this new version? Were there any major issues or preparation to existing system?Thanks for your help.
717 Jul 2009 @ 08:28 PDTDatabaseReplyRegarding Query Infosyntax look correct.Nested case syntax is below (same as typical if ...else)case when condition1 then case when condition 2 then result2 else result3 endelse result4end
610 Jul 2009 @ 05:01 PDTDatabaseReplyCron SchedulingCrontab works differetly than your command prompt so make sure that you have full path inside when you refer any module.type mail on command prompt and see for the errors.
510 Jul 2009 @ 03:00 PDTDatabaseReplySpool Space ErrorSpool space is usually good enough for the individual users. You may have to look at the SQL and see if there is any problem. Use Explain and see how many result rows you are getting...I have past ...
410 Jul 2009 @ 02:57 PDTDatabaseReplyteradata adminI tried this but no luck.
309 Jul 2009 @ 06:35 PDTDatabaseTopicteradata adminI have created a role and granted this role to the user but the user can't access the database that is granted to the role.I have executed the follwoing.create role x;grant select on edw_tb to x;gr...
209 Jul 2009 @ 06:23 PDTAnalyticsTopicTeradata adminI have created a role and granted this role to the user but the user can't access the database that is granted to the role.I have executed the follwoing.create role x;grant select on edw_tb to x;gr...
125 Oct 2007 @ 06:05 PDTDatabaseReplycheck for numeric values in a stringI am trying to check to see if the string is a numeric or alpha-numeric. I have tried the following but it is not giving right results.case when cola like '%1%' orcola like '%2%' orcola like '%3%'...