DSXchange

[quote="DSguru2B"]I finally got a chance to write a small bat script to do this for you. Here ya go. [code] @echo off REM Set variables set last="" set fileToParse=%1 set tmpFile=%2 for /f "tokens=1-4 delims=/.- " %%A in ('date /t') do (set Dow=%%A&set mm=%%B&se...

[quote="ray.wurlod"]For a sufficiently small number of stores, a Transformer stage with that many outputs (one per store) is the most convenient solution in a server job. The file names (in the downstream Sequential Fil ...[/quote] Ray, I thought about it. But it is going to be 300 stores ...

[quote="DSguru2B"]I just re-read the post. You really are on server edition arent you. I missed that part although it was right in my face. :oops: Go ahead and post some sample data, it might help us come up with a solution.[/quote] Thanks for the response. Yes, I am on server edition. Her...

[quote="DSguru2B"]Do you have MKS Toolkit installed? It should be as your running px on windows. If you can confirm that then you can do this with a shell script.[/quote] No. But I think I can install it on the server. Will it help? But it is prefered, if there is anything can be done with...

Hello datastage gurus, I need some helping hand for my situation. I need to create files based on the values in a column. I get the source data file with sales information from different stores. On the other end at the target, I have to create the files for each store no. in the source file. I have ...

Hello everybody, I am trying to submit a job which is on AS/400, from datastage. Its like a remote command. Is there an easy way to do it? I tried using FTP stage and gave it as telnet command. But it is expecting the remote path and filename, which I dont think I need to go for. Any help on this is...

I tried that option too. I got that from www128.ibm. It didnt work. As you said I tried putting system32 path at the end. Is it possible to know whether Datastage is looking for AT in some other location rather than system32? C:\Documents and Settings\dsadmin>path PATH=C:\WINDOWS\system32;D:\PROGRA~...

[quote="asitagrawal"]Can u provide the step by step procedure of how u are scheduling?[/quote]

I am using the Director and saying Add to Schedule and specifying the timings.

Hello everyone, I am getting the following error while scheduling a job in datastage. "Error adding to schedule: at: garbage after time specification (Command was: AT 09:43:43 vmdsr_sched.exe d:\apps\ascential\DataStage\Projects\Test" I looked through the forum. But none helped. It talked ...

Thanks. It worked. I didnt realise that there is a link collector in Server edition. It is same as what kcbland suggested.

[quote="asitagrawal"]How many fields are there in the input ?[/quote]

I have 18 fields. Are you talking about @VM?

[quote="kcbland"]3 output links from a Transformer going into a Link Collector/Hashed file/3 separate Sequential files/etc. ...[/quote]

Is there a better option than having 3 sequential files. I need to have all those 3 records in a single sequential file.

Hello everyone,

Is there an option in a job to duplicate the records from the source file. I need to create 3 duplicated records from a single record. Any help would be appreciated.

Version: Server
Os: Windows

Thanks,

[quote="narasimha"]Use only $GroupMailId to get the value, you don't require to enclose it in between #'s[/quote]

Wow!. That worked. Thanks a lot Narasimha.

Good morning everyone,

Is there any function to get the value of the environment variable which can be used in the transformer. I tried using the variable as it is #$GroupMailId#. But it didnot work. It is taking the variable itself as the value. Any help?

Version: Server
OS: Windows.

Thanks,