DSXchange

Current_Timestamp is an Sql teradata variable. I Agree with you about the format of the TimeStamp in DataStage but I would like to use this current_Timestamp as it is more accurate. When I see the Log report, I have this message : "DML label name 'TDMLOAD' was not previously defined." TDML...

Hi all, I would like to assign the value Current_Timestamp directly at the level of the loading stage. My first attempt of replacing the value ":MOD_DT_TM" by Current_Timestamp resulted in an error. Mload Script: dml label tdmload do update the existing rows; UPDATE #ThisDataBase#.#Table# ...

Hi, I see 4 possibilities: 1.You can declare an environment variable from Administrator and set your jobs to read from this variable. 2.If you are using job sequencers, put your variable on the top sequencer and make your job refer to it. 3.You could use a routine that would always use at run time v...

Hi, If you want to effectively kill your jobs, make sure the option Enable job administration in Director (Administrator) is checked. You will have access to clean-up ressources in Director where you can get rid of any job. Otherwise, you can type in Administrator list.readu to know what are the act...

Hi, You cannot at this time send an attachement using DSSendMail. If you want an easy way to bypass this, you can put all your data in variables and include it in the body. An another would be to take advantage of the fact that you can execute DOS and UNIX commands to send an email through a simple ...

We have been using it for a short time but it seems to work fine with Server. However, we have had problems reading and writing dates on our DB using Parallel Extender. Ascential developed a patch and things are fine now.

Regards

MAT

Thanks a lot!!

MAT

Hi all,

I wonder if any of you has tried to change the project of version control under DS 6.x. I think it has to be done from the registry but I can't find the place.

Regards

MAT

Hi, Since I do not use MetaStage, I can't help you with your question on this but for DSMakeJobReport(...), here's how I use it: DSMakeJobReport(JobHandle, ReportLevel, LineSeparator) JobHandle is what you get from DSAttachJob ReportLevel is a number 0=basic and 1=detailed Lineseparator is the strin...

ap_nat,

I have sent you the doc about plug-ins

(Just for others to know [8D] )

MAT

Hi,

try converting your date before loading:

Iconv("your date", "D-YMD[4,2,2]")

Worked for us

MAT

Hi all, If anyone is interested in the rtypes used in various PX functions, here they are: Rtype. The rtype argument is a string, and should contain one of the following: * ceil. Round the source field toward positive infinity. E.g, 1.4 -> 2, - 1.6 -> -1. * floor. Round the source field toward negat...

Hi BP, Thanks for the infos, I'll try what you suggest about using buildop. I will also post the rtypes in my topic related to the StringToDecimal function. Also, to answer your question "why is CurId a string to begin with?". It is because it is an environment variables therefore string i...

Hi BP, Part 2 is not working [:(]. I think because of the type conversion function StringToDecimal that we discussed yesterday. I could not find the rtype options in my doc and it appears it was not included. Ascential sent me the function documentation which should be included in a future release o...

Hi, The project I am working on will integrate data coming from various sources not necessarily compatible with each other. For that reason, we need to associate every record we handle with a unique ID number. Since we are using PX, we can't access sdk functions like keymgt inside a job transformer....