try to create file in location

[former_member203645]

Please help me with command fix,

I am trying to create a file after cycle completing in location.

Below is the command using in the script :

print('Attempting to create [$GV_OUTBOUND_DIR][$GV_FILE_NAME]');

print(exec('/bin/sh','-c "touch [$GV_OUTBOUND_DIR]/[$GV_FILE_NAME]"',8));

Variables :

$GV_OUTBOUND_DIR] - added path O:\Project\++Projects\Cube\ETL_Unit_test

[$GV_FILE_NAME] - File name with extension, eg: FILEGEN.txt

Error Message:

25023	353486624	PRINTFN	6/20/2016 2:37:37 AM	Attempting to create O:\Project\++Projects\Cube\ETL_Unit_testFILEGEN.txt
25023	353486624	PRINTFN	6/20/2016 2:37:37 AM	1: touch: cannot touch `O:Project++ProjectsCubeETL_Unit_test/FILEGEN.txt': No such file or directory

[former_member187605]

\ is the escape character in DS scripting.

Replace any \ by \\.

[former_member203645]

I replaced \ with \\  but I think I am still missing something, it not generating file

print('Attempting to create [$GV_OUTBOUND_DIR][$GV_FILE_NAME]');

print(exec('/bin/sh','-c "touch [$GV_OUTBOUND_DIR]\\[$GV_FILE_NAME]"',8));

[$GV_OUTBOUND_DIR]  O:\Project\++Projects\Cube\ETL_Unit_test

[$GV_FILE_NAME] FILEGEN.txt

Error message:

28445	3815888672	PRINTFN	6/20/2016 8:11:07 AM	O:\Project\++Projects\Cube\ETL_Unit_test
28445	3815888672	PRINTFN	6/20/2016 8:11:07 AM	FILEGEN.txt
28445	3815888672	PRINTFN	6/20/2016 8:11:07 AM	Attempting to create O:\Project\++Projects\Cube\ETL_Unit_testFILEGEN.txt
28445	3815888672	PRINTFN	6/20/2016 8:11:07 AM	0:
28445	3815888672	JOB	6/20/2016 8:11:08 AM	Job <JB_CYCLECOMPLETE> is completed successfully.

[former_member470982]

Hi,

Can you check this?

[$GV_OUTBOUND_DIR]  O:\\Project\\++Projects\\Cube\\ETL_Unit_test\\

[$GV_FILE_NAME] FILEGEN.txt

BR,

Srinivasan.

[former_member203645]

nope it didn't worked.

[former_member187605]

Yes, I see, now. You're trying to create a file using a Linux command. And you're using a Windows path.

That will never work, will it?